Exporting Excel Contacts and mailing to Outlook, 2003 versions.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PB - 14 Aug 2007 21:44 GMT

I'm having troubles exporting an excel file xls. into outlook for a large
contact section, I've tried everything i can but something seems to want to
work, the last thing i want to do is type every contact out onto outlooks
contact section as i have over 150 contacts complete with name, address,
phone number, etc. The one suggestion i noticed the most was re-naming the
cells to show how much of the data i want imported into outlook, I've tried
that and to no avail keep getting my excel file un-accessible to outlooks
contacts, thanks...

Reply to this Message

Karl Timmermans - 14 Aug 2007 22:10 GMT

Your description is a little confusing so just to clarify:

#1 - You don't export from Excel to Outlook - you import an XLS file from
Outlook (using the import wizard) into your desired Outlook contact folder
#2 - If you're importing an Excel worksheet - you need to have a "named
range" for the data you want to export. Or a much more simpler approach if
you're not familiar with what a "named range" is - just save the worksheet
as a CSV file and import that file using Outlook's import wizard
#3 - No need to re-name any cells in either case - just make sure you "map"
the correct fields. In fact, a whole lot safer then using Outlook's
"automap" feature.

Since you haven't provided any other info - the above assumes the following:

#1 - Target contact folder is located in a PST file or in your Exchange
Mailbox (if using Exch)
#2 - You are not using any custom forms (to import any data to ANY
user-defined fields whether or not a custom form is being used)
#3 - Your question was not related to using your Excel file as your "contact
source" for everyday operations (you can't)

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'm having troubles exporting an excel file xls. into outlook for a large
> contact section, I've tried everything i can but something seems to want
[quoted text clipped - 6 lines]
> that and to no avail keep getting my excel file un-accessible to outlooks
> contacts, thanks...

Reply to this Message

Brian Tillman - 14 Aug 2007 22:11 GMT

> I'm having troubles exporting an excel file xls. into outlook for a
> large contact section,

You can't export using Excel into Outlook. You must import from an Excel
spreadsheet (or a comma-separated values file) using Outlook. Exactly how
are you trying to perform the operation?

Signature

Brian Tillman [MVP-Outlook]

Reply to this Message

PB - 14 Aug 2007 23:38 GMT

Yea sorry i've never been good at explaing things when i get frustrated lol,
anyway yes the CSV. file worked and i mapped everything accordingly thank you.

PB.

> > I'm having troubles exporting an excel file xls. into outlook for a
> > large contact section,
>
> You can't export using Excel into Outlook. You must import from an Excel
> spreadsheet (or a comma-separated values file) using Outlook. Exactly how
> are you trying to perform the operation?

Reply to this Message