export from excel to OL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RandyPerry - 12 Feb 2008 00:46 GMT

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?

Reply to this Message

Judy Gleeson (MVP Outlook) - 12 Feb 2008 00:50 GMT

from Outlook, use the Import/export wizard. File | Import.

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

Signature

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

>I use office 2007. I have a data base of homeowners in Excel (I'm the
>assoc.
[quoted text clipped - 4 lines]
> set up in OL 2007.
> Can I do that? How?

Reply to this Message

Karl Timmermans - 12 Feb 2008 03:55 GMT

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

>I use office 2007. I have a data base of homeowners in Excel (I'm the
>assoc.
[quoted text clipped - 4 lines]
> set up in OL 2007.
> Can I do that? How?

Reply to this Message