I have a SharePoint 2007 list, I want to Auto-populate the Email id based on the Account Name(Person/Group type column).
Eg: if the persons account name is provided in the Account name column then his/her email id should get auto-populated in the Email id column of the same List.
Please provide a calculated formula for the same.