Automatic Email in separate column from PeoplePicker column

Question

_{Wednesday, April 11, 2012 3:05 PM}

Hi - I have a SharePoint list with a "Name" column that contains names from a People Picker.  Is it possible to have an "Email" column in the list that automatically updates with the email address of ther person in the "Name" column?  Can this be done without too much code as I have limited rights to user Designer or anything else.

I guess I could do this manually by adding another people picker to display the email address, but there are 155 items in it already and this would be a pain to do.

Thank you!

All replies (4)

_{Wednesday, April 11, 2012 4:25 PM ✅Answered}

Hi,

I would suggest, create person and group with name WorkEmailAdd as an additional column in your list, and set showfield as an same as Name. Now add both the columns in your view, and open this view in Datasheet View. Copy Name column value from column header to end and paste it into newly created column WorkEmailAdd and then go to this column setting and set showfield as workemail. 

I hope this would at least reduce your pain to update all the items manually. For future updated values insist your user to add values on both the columns.

Hope it helps.

Arpan Shah

_{Friday, April 13, 2012 8:15 AM ✅Answered}

Hi Nalani,

As Arpan said, using "Datasheet View" of the list to manually edit the "person or Group" type column will be more efficient.  

You can set "Email" column display as "account" type, then edit the user account in "Email" column directly(or edit account in Excel then copy them), then change the "Email" column display as "Work Email".

Thanks

Daniel Yang

TechNet Community Support

_{Wednesday, April 11, 2012 3:40 PM}

Hello,

Try this:

1. First create a column "Email" with type as "Person or Group".

2. Next under "Additional Column Settings" in the "Show field:" select the "Work Email" option.

So now when the you enter the user name in the "Email" column and save the info you will get the Email address of that person.

Note: For this to work, you need to configure the User Profile Synchronization properly

Hope the information helps!

Thanks & Regards, Chandra Shekhar

_{Wednesday, April 11, 2012 4:12 PM}

Thank you for your reply.  I was trying to pick the name, as I need to show that, and then have the email show up automatically in a separate column, so that I can reference it directly.  I have the list sent to Excel and refreshing automatically, but also need the email address of the person. I guess I will have to do this manually.