Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I'm having problems exporting contacts from excel to outlook
|
#2
|
|||
|
|||
Export as CSV file
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "james" wrote in message ... |
#3
|
|||
|
|||
james
The basics........Your layout may differ, but adjust to suit. First have the names and email addresses in Excel in two columns. I set up also a third column with the names duplicated so when you Import to Outlook you have a name for the Contact and a Display Name instead of the email address in the To: box. FileSave AsFile Type CSV(comma delimited)(*.csv) Now open Outlook and FileImportExportImport from another fileComma Separated Values(Windows)NextFile to Import(you can browse to your saved *.csv file). Next you will be asked where to import them to. I bring mine to "Contacts". Follow the instructions and you will get a Map. Drag your names and addresses to the appropriate spots on the Map 1. Name of Contact 2. Email address1 3. Display Name(if you have one by making the duplicate column mentioned earlier). If not, the email address wil be displayed in the To: box. Continue with the OK's until Outlook pulls all from the *.csv file(should take only a few seconds). Now they are in the Contacts folder, you can group them as you wish. Gord Dibben Excel MVP On Sun, 5 Dec 2004 11:19:02 -0800, "james" wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Copy/Paste into Outlook | Excel Discussion (Misc queries) | |||
Excel 2002 vs Outlook 2003 | Excel Discussion (Misc queries) | |||
moving 450 active e-mail addresses from Excel to Outlook Express | Excel Discussion (Misc queries) | |||
Problems with Excel 2003 Help menu | Excel Discussion (Misc queries) | |||
Excel and OUTLOOK | Excel Discussion (Misc queries) |