Importing Address List from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carmen Oien - 27 Jan 2004 20:45 GMT

I'm trying to import an address list from Excel, but keep
getting an error message telling me the "range" hasn't
been defined. I'm not a neophyte but can't think of what
needs to be done to import the list. So far, I have made
sure the column headings are the same as Outlook/Contact
defined headings, attempted to define the range in several
places (which hasn't worked), and talked to our help desk
(ditto). Tried changing to a .txt file - it imported, but
only the contact names, no addresses. I'm stumped!

Reply to this Message

Sue Mosher [MVP] - 27 Jan 2004 21:00 GMT

Before you save the worksheet, select the data you want to import, then
choose Insert | Name | Define and give it a name. Then save and import.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> I'm trying to import an address list from Excel, but keep
> getting an error message telling me the "range" hasn't
[quoted text clipped - 5 lines]
> (ditto). Tried changing to a .txt file - it imported, but
> only the contact names, no addresses. I'm stumped!

Reply to this Message

- 27 Jan 2004 21:09 GMT

A-ha! I'll give it a try. Thanks!

>-----Original Message-----
>Before you save the worksheet, select the data you want to import, then
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

- 27 Jan 2004 21:21 GMT

This didn't work -- any other ideas?

Reply to this Message

Sue Mosher [MVP] - 27 Jan 2004 21:44 GMT

What happened when you tried?

The newsgroup interface you are using apparently does not quote earlier
messages in the thread, making your latest message so short on detail that
you risk not getting the answer you're looking form. Please take the time to
quote the original message.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> This didn't work -- any other ideas?

Reply to this Message

- 27 Jan 2004 21:45 GMT

Oh, sorry. I didn't realize you wanted to see the previous
e-mails. What happened - it successfully imported, but I
have customized fields (Title, First Name, Last Name,
Address, City, State, Zip/Postal Code) and only the Last
Name and Zip/Postal Code were imported.
Thanks!

>-----Original Message-----
>What happened when you tried?
[quoted text clipped - 7 lines]
>
>.

Reply to this Message

Sue Mosher [MVP] - 27 Jan 2004 21:58 GMT

Did you use the data mapping dialog to map fields between Excel and Outlook?

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Oh, sorry. I didn't realize you wanted to see the previous
> e-mails. What happened - it successfully imported, but I
> have customized fields (Title, First Name, Last Name,
> Address, City, State, Zip/Postal Code) and only the Last
> Name and Zip/Postal Code were imported.

> >> This didn't work -- any other ideas?
> >
> >.

Reply to this Message

- 27 Jan 2004 22:29 GMT

Yes, thanks - it mostly worked, after I mapped it; the zip
codes imported with a ".000" extension that I had to
delete by hand, but otherwise it saved me a lot of time
(even spending most of the day working to import it).
Thanks again.

>-----Original Message-----
>Did you use the data mapping dialog to map fields between Excel and Outlook?
[quoted text clipped - 9 lines]
>
>.

Reply to this Message

Karl Timmermans - 27 Jan 2004 21:49 GMT

Two things you should do:

#1 - Save your file to .CSV format and just to be sure it has all the data
you want in that file open it again in Excel
#2 - If it doesn't have all your data - clear out all your named
ranges/print area etc that you've created for this and start fresh
#3 - Import the CSV file and I suggest that you "explicitly" map your fields
and not let Outlook automatically
assign them for you - your data may be getting imported but not to
where you're looking or the column name
you assigned is NOT "identical" to Outlook's (most likely the case if
you're using automap)

Karl

Signature

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com

> This didn't work -- any other ideas?

Reply to this Message