I have an excel spreadsheet with the following headings:

Name
Mobile
Home
Work
Street Address
Suburb
Post Code

Can I import this data into Outlook to be my contacts file? If so, how? This
is a new account being set up so there are no current contacts.

Thanks in advance

Select the range of data including the headings.

InsertNameDefine. Give it a name like MyContacts

Save the workbook.

Open Outlook and FileImport/ExportImport from another programMS Excel

Browse to the Excel file and select it then follow your nose through selecting
the Contacts folder and mapping the fields.

Alternative to naming the range is to save the Excel workbook as a *.CSV file
and import that into Outlook.


Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 14:29:00 -0800, markmcd
wrote:

I have an excel spreadsheet with the following headings:

Name
Mobile
Home
Work
Street Address
Suburb
Post Code

Can I import this data into Outlook to be my contacts file? If so, how? This
is a new account being set up so there are no current contacts.

Thanks in advance

If you could help me on a similar question you answered before but I am
trying to do this for importing a group work schedule for the month from
excel into the calendar. I have exported a month from the calendar into
excel - and want to then create the next month by a similar format and import
it into Outlook. This has worked but only for the first three records - any
suggestions

"Gord Dibben" wrote:

Select the range of data including the headings.

InsertNameDefine. Give it a name like MyContacts

Save the workbook.

Open Outlook and FileImport/ExportImport from another programMS Excel

Browse to the Excel file and select it then follow your nose through selecting
the Contacts folder and mapping the fields.

Alternative to naming the range is to save the Excel workbook as a *.CSV file
and import that into Outlook.


Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 14:29:00 -0800, markmcd
wrote:

I have an excel spreadsheet with the following headings:

Name
Mobile
Home
Work
Street Address
Suburb
Post Code

Can I import this data into Outlook to be my contacts file? If so, how? This
is a new account being set up so there are no current contacts.

Thanks in advance