Updating Excel contacts to Outlook

[Far Raider]

My Dad got a PPC a while ago and told me he still has all his contacts in an Excel spreadsheet because the task of entering them into Outlook is too daunting/monotonous. Is there an easy way to transfer the data? Perhaps designate fields in Excel to be read by Outlook contacts? Thanks for any help.
FR

[Jukov]

Would THIS help?

Would THIS help?

I should imagine that would

One point - take your time mapping the custom fields - as this affects all the contacts imported - it is better to really think about this and do it right first time.

A useful way to do this is to go into Outlook and enter all the information for one or two contacts, then go to File>Import and Export, Export to a file> Choose an excel file.

Have a look at the file created and make sure your existing data is in a similar format.

I recommend that what you actually do is copy/paste the data from your existing spreadsheet into this one.

Yes it will take time, but it will be much quicker than entering all the data into Outlook - and MOST IMPORTANTLY - when you import it into Outlook it will populate the fields right first time :approve:

Let us know how you get on.

[Far Raider]

Thanks, that is JUST what he needs. I pass it on but as you know you can lead horses to water but...

I'll let you know how it goes.

FR