Outlook 2010 Correct way to map multiple contact fields

Not open for further replies.


Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
I am trying without success to import an Excel CSV list of club members, I have succeeded except for the address fields. I had listed them in separate columns as:
ALAN SMITH,ASMITH@ANYONE.COM01234 56785607777 7777771. The HouseRigmore StSomewhereNearer ab1 2cd
That did not work on the address so merged the address columns into one column and pasted the result into a new column named Home Address as a Value. But that did not work either. There are 91 members to add to MY CLUB Contacts folder and I'd rather do the job as a batch not individually!
Thank you in advance for any suggestions.

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Did you merge the columns as Street, City, Postal code - these are the specific field names outlook uses:

Home StreetHome Street 2Home Street 3Home CityHome StateHome Postal CodeHome Country/Region

Also, click on Map Custom fields then check the mapping. If you use Outlook's field names, it will match them automatically but if not, you need to map the fields.



Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
Hi Diane.
Many thanks, now got it sorted, sort of..
I have my members in an address book but need to change the File As from last First to First First. As in Bloggs Joe to Joe Bloggs. Also need to Display as Joe Bloggs not as: Joe Bloggs (joebloggs@anywhere.com). Can this be done as a batch or do I need to do each one one at a time?


Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
Thank you Diane. Think I need some time to read and understand the guide, if I chicken out and have a spare evening I might do it by hand!
Not open for further replies.
Thread starter Similar threads Forum Replies Date
L Correct E-Mail Pulling Wrong Mail Using Outlook 0
L Email with correct To address but displaying name of a related person Using Outlook 0
J Sent Items Folder NOT Showing Correct From Email Address Using Outlook 0
witzker Correct Format of custom Yes/No Checkboxes Outlook VBA and Custom Forms 0
Fozzie Bear Correct Method to set up Outlook.com accounts as Exchange Using Outlook.com accounts in Outlook 7
Thorsten show the correct calendar on start Outlook VBA and Custom Forms 5
R Correct a wrong csv export file from WLM 2012 Using Outlook 0
R VBScript Sendmail not selecting correct 'from' address Outlook VBA and Custom Forms 3
I Large emails not sent from correct account Using Outlook 0
J Importing to the correct calendar from Excel 2010 to Outlook 2010 Outlook VBA and Custom Forms 2
A phone numbers fields in BCM are not correct BCM (Business Contact Manager) 3
E Getting Outlook full name correct with AddressLayout Using Outlook 1
D Journal problem recording correct phone number Using Outlook 7
P correct public folder migration exchange 2003 to 2010 Exchange Server Administration 1
B Outlook 2010 asking for password constantly, won't accept correct one Using Outlook 5
M help correct code Using Outlook 0
J Correct settings for send/receive groups w/Exchange Using Outlook 3
A Need method to rapidly correct telephone contact telephone number formatting Using Outlook 1
D How to correct Outlook Connector Live ID Using Outlook.com accounts in Outlook 1
D appointments on To Do Bar don't reflect the correct Calendar Using Outlook 3
M Auto-correct Contact fields' formatting? Using Outlook 7
B Trying to find & run Scanpst.exe. Outlook can't log onto server. Have removed update KB2412171 & it did not correct problem. Have done a resto Using Outlook 2
H Correct e-mail address format in address book in GAL Exchange Server Administration 3
L When I click on links within Outlook they always go to my website's homepage instead of going to the correct url. Using Outlook 2
D Sending mail from an IMAP account does not store sent mail on the correct folder Using Outlook 1
A The auto correct feature doesn't work on all the programs word, outlook, etc. Also when I try to us Using Outlook 1
R Way to correct the window in focus when creating a task from email? Using Outlook 1
S __Below are the errors listed in my Outlook Send?Receive. How do I correct them?__ Using Outlook 1
N I can't get my out of office reply to work. I know it is set up correct. Please help!! Using Outlook 2
T outlook auto correct Using Outlook 5
S Outlook 2010 losing correct logon details when connecting to Exchange 2010. Using Outlook 3
C Dot Matrix Printer: When I try to print a mailing label the printer button is greyed out. I have the label printer as my default. I have the correct Using Outlook 1
S Task Email Attachment Shows Incorrect Email Subject, Opens Correct Email w/ Correct Subject Using Outlook 1
W Not using the correct email account when replying to emails that have arrived after being forwarded from one email account to another Using Outlook 1
E After 2010 Office Beta expired, my 2007 Outlook version stopped working properly. Can not access correct profile and synchronization with Blackberry p Using Outlook 1
J Re: Please help correct Error on step 4 of converting Windows mail to Office Outlook 2007(already installed). Using Outlook 3
J Inbox time wrong, all others correct Using Outlook 1
F Correct email dates corrupted during importing from Outlook Express Using Outlook 1
J meeting request not correct (time) Using Outlook 1
D Outlook 2010 - Mark Unread button isn't always in the correct state Using Outlook 4
A Second Exchange 2010 SP1 OWA login fail "The username or password you entered isn't correct. Try ent Exchange Server Administration 3
S In Microsoft Outlook 2003 I have a Adobe PDF icon, to convert emails to pdf and then save them in the correct folder/file and it is not working anymor Using Outlook 1
S In Microsoft Outlook 2003 I have a Adobe PDF icon, to convert emails to pdf and then save them in the correct folder/file and it is not working anymor Using Outlook 1
M Outlook 2007: Is there any subject header auto correct option? Using Outlook 1
S auto-correct not working on Outlook 2010 Using Outlook 5
W Accidently typed in wrong Windows Live ID during Outlook setup, now cannot change to the correct Live ID and unable to have any access to Microsoft Ou Using Outlook 2
S Send receive with ATT returns this error: 0x800CCC92 . My password is correct. Using Outlook 2
K Why is OL not keeping the correct sender account? Outlook VBA and Custom Forms 1
E Some question if I understand user properties correct Outlook VBA and Custom Forms 3
Similar threads