Excel to Outlook

  • Thread starter Thread starter markmcd
  • Start date Start date
M

markmcd

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.

Insert>Name>Define. Give it a name like MyContacts

Save the workbook.

Open Outlook and File>Import/Export>Import from another program>MS 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
 
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
 
Back
Top