Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel list as Outlook Contacts
- Thread starter Katy
- Start date
mscallisto
Technical User
Outlook has an import function that's quite easy to use.
Check it out in the Outlook Help.
Much Luck
Check it out in the Outlook Help.
Much Luck
One problem that he might encounter is that he might get an error when importing to Outlook that says something about there not being a named range. What this means is that he will need to highlight the table in Excel and give it a name in the name box (left of formula bar). It is a very easy fix but usually throws people off.
Another issue is to be sure to map the email field to the proper field in Outlook. There is a way to expand the fields under the email heading, so that you map to one of the fields and not to the heading which is the temptation when it is collapsed.
I so hope this makes sense, it is hard to explain in writing. Just thought I would share some common issues I have seen people deal with in importing to Outlook from excel.
Dawn
Another issue is to be sure to map the email field to the proper field in Outlook. There is a way to expand the fields under the email heading, so that you map to one of the fields and not to the heading which is the temptation when it is collapsed.
I so hope this makes sense, it is hard to explain in writing. Just thought I would share some common issues I have seen people deal with in importing to Outlook from excel.
Dawn
- Status