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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
From an Excel Table to Outlook contacts. 1
- Thread starter nat101
- Start date
-
1
- #2
Sure.
I would create a new contacts folder in Outlook first.
Then hit File-Import and Export from Outlook's menu, and choose from an excel file....etc. It will ask you to map fields. YOu will want to have it match, for instance, an email field in Excel with an email field in Outlook. Anne Troy
I would create a new contacts folder in Outlook first.
Then hit File-Import and Export from Outlook's menu, and choose from an excel file....etc. It will ask you to map fields. YOu will want to have it match, for instance, an email field in Excel with an email field in Outlook. Anne Troy
- Thread starter
- #3
UKalliance
MIS
You may find that you have to save the Excel spreadsheet as a CSV file to be able to complete the process. I did on our machines at work. Otherwise you may get an error about not being able to recognise the file format of an .xls file. ________________________________________
The Collective known as
The UK Alliance
________________________________________
The Collective known as
The UK Alliance
________________________________________
Same way, 5656. File-Import and Export...to an Excel file... Anne Troy
Word and Excel Macros
Word and Excel Macros
- Status