Importing .csv file into Outlook

  Liteman 18:00 04 Feb 06
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 06

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 06

I'll give it a go!

  Liteman 18:11 04 Feb 06

...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 06

Do them all, even if they're blank.

  Liteman 18:38 04 Feb 06

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Fresh New Fonts of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced