Importing .csv file into Outlook

  Liteman 18:00 04 Feb 2006
Locked

Hi - Outlook 2002, Win XP. I've imported a .csv file of names, addreses and email addresses into Outlook (not Outlook Express) but only the names have appeared.

Can I do somthing which will add the other details, or do I have a major typing exercise ahead of me? I want to do an email mail merge eventually.

Thanks

exmpdragon

  Forum Editor 18:08 04 Feb 2006

1. Open the file in Excel.


2. Click 1 to select the first row, click Insert, and then click Rows.


3. In the first row that you just created, starting with cell A1 and continuing across to cell A20, enter the following fields to create header names for each column:


• First Name
• Last Name
• Title
• Company
• Work
• Home
• Other
• E-mail
• Address
• City
• State
• ZIP Code
• Country
• Custom 1
• Custom 2
• Custom 3
• Custom 4
• Note
• Private
• Category


4. Click File, and then click Save.

  Liteman 18:09 04 Feb 2006

I'll give it a go!

  Liteman 18:11 04 Feb 2006

...do all 20 headers need to be completed as above? In the main, I only have names, addresses and emails. Can I just name the columns I have?

  Forum Editor 18:34 04 Feb 2006

Do them all, even if they're blank.

  Liteman 18:38 04 Feb 2006

OK, thanks. Unfortunately, the person who created the mailing list put first & last names in one column, and ran several lines of the address over different columns...

Oh well, it'll go better with a nice glass of the red stuff, methinks!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?