How do i transfer a database from excel to outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hayden - 29 Jan 2006 20:10 GMT

I have a database of all my contacts in an excel spreadsheet. What is the
easiest way to transfer the information so that my client information which
is on a complete row on the excel spreadsheet will appear as one record on
outlook.

Thank you for your help.

kindest regards,

Hayden

Reply to this Message

Judy Gleeson MVP - Outlook - 30 Jan 2006 03:34 GMT

If you have the same content as exists in Contacts then make sure you know
what each field is called in Excel. If you have extra content eg their
height, you will need to make the extra field in Outlook first. Do this in
Phone List View and use the New button on the Field Chooser from the
Advanced Toolbars.

Name the range in Excel. Close Excel.

In Outlook, File | Import | From Excel follow the bouncing balls of the
Import Export Wizard.

Judy Gleeson - MVP Outlook
Acorn Training and Consulting
Canberra, Australia

see what Outlook training can do to improve productivity:
www.acorntraining.com.au/pdfdocs/ProductivITwithOutlook.pps

www.acorntraining.com.au/productivit.htm

> I have a database of all my contacts in an excel spreadsheet. What is the
> easiest way to transfer the information so that my client information which
[quoted text clipped - 6 lines]
>
> Hayden

Reply to this Message