Import Excel List to Contacts

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have large Excel file that I use for a mailing list. I would like to
import this list into Outlook 2002. If I attempt this using the
Wizard, will all of the entries be entered into Contacts, as if I had
typed them all individually?

There are 300+ names so I am looking to avoid all that typing.

Is there anything that I would have to do to the Excel file to prepare
it for import?

All help appreciated
Thanks
 
Tom said:
I have large Excel file that I use for a mailing list. I would like to
import this list into Outlook 2002. If I attempt this using the
Wizard, will all of the entries be entered into Contacts, as if I had
typed them all individually?

There are 300+ names so I am looking to avoid all that typing.

Is there anything that I would have to do to the Excel file to prepare
it for import?

All help appreciated
Thanks
Click to expand...

Make sure that the data is in a named range. If you don't know how to do
that then just save the Excel file as a CSV file and import that.
 
Make sure that the data is in a named range. If you don't know how to do
that then just save the Excel file as a CSV file and import that.
Click to expand...

***************************************************************
Thanks for the info, but will that enter them into Contacts as if I
had typed them? Should I have a header row, does it need to be in a
particular format ie: (LastName, Firstname, etc...)

How does the import handle leading zero's in zip codes for example?

Thanks
 
***************************************************************
Thanks for the info, but will that enter them into Contacts as if I
had typed them? Should I have a header row, does it need to be in a
particular format ie: (LastName, Firstname, etc...)

How does the import handle leading zero's in zip codes for example?

Thanks
Click to expand...
Export a contacts folder into a CSV.
Place cursor into the A2 cell
Press Ctrl-Shift-End
Press del

This gives you an accurate template that will import properly. Paste
your existing data accordingly.
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)
 
Tom said:
***************************************************************
Thanks for the info, but will that enter them into Contacts as if I
had typed them? Should I have a header row, does it need to be in a
particular format ie: (LastName, Firstname, etc...)

How does the import handle leading zero's in zip codes for example?

Thanks
Click to expand...

In Outlook create a dummy Contact and then export that to an Excel File.
Compare your file with that one and modify it accordingly.
 
I have large Excel file that I use for a mailing list. I would like to
import this list into Outlook 2002. If I attempt this using the
Wizard, will all of the entries be entered into Contacts, as if I had
typed them all individually?

There are 300+ names so I am looking to avoid all that typing.

Is there anything that I would have to do to the Excel file to prepare
it for import?
Click to expand...

Mail merge has no problem using an Excel spreadsheet as an address source.
Why bring it into Outlook?

If you really want to do that, see this:
http://www.slipstick.com/tutorials/create/dl.asp
 
Mail merge has no problem using an Excel spreadsheet as an address source..
Why bring it into Outlook?

If you really want to do that, see this:http://www.slipstick.com/tutorials/create/dl.asp
Click to expand...

I use mail merge when doing bulk mailing using Avery Address sheets,
however I sometimes need to send out individual labels that would be a
waste of using a whole sheet, so I bought a Dymo label writer which
encourages using Outlook.

When I import from Excel, should I be using a header row?
 
Back
Top