export from excel to OL

  • Thread starter Thread starter RandyPerry
  • Start date Start date
R

RandyPerry

I use office 2007. I have a data base of homeowners in Excel (I'm the assoc.
president) and I want to export my HO data i.e. first & last name, address,
phone #, email address, etc from my Excel file to a new contacts group I have
set up in OL 2007.
Can I do that? How?
 
from Outlook, use the Import/export wizard. File | Import.

You need to name the range in Excel first and close the workbook.

--
Here are some tips about how to post questions:
http://support.microsoft.com/?id=555375

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant

There are various articles about using Outlook here:
www.judygleeson.com/articles.aspx
Canberra, Australia

"What do we live for, if it is not to make life less difficult for each
other?"
George Eliot
 
Just to add one minor but important item to Judy's instructions - make sure
that you save your Excel worksheet in Excel 97-2003 (.xls) format since
Outlook doesn't support the Excel '2007 .xlsx format as an import file type.
Alternatively, you can save your worksheet as a CSV file and import that
instead which also negates the need to define a <named range> in Excel (at
least for the purposes of importing into Outlook).

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
Back
Top