Import contact list from excel
 

Comments inline below

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


wrote in message oups.com...
Hi, I am trying to import an excel spreadsheet into Outlook. I have a
few queries.

Firstly, the import process itself works fine - I map the fields to the

location I want them to go, including email address, and import the
data. However, my queries are as follows:-

Query 1: The File As section is displaying as Last Name, First Name. I

need this to be displayed as Company. Is there a way of doing this as
a bulk change for all contacts? There are about 380 of them and I
don't relish having to change each one manually!

Outlook provides no way to specify the File As on imported data. You could, however, write a simple VBA code routine to make the change using the same structure as in the sample at http://www.outlookcode.com/d/code/convertfields.htm

Query 2: My email addresses are coming through incorrectly. The field
is just displaying a single character e.g. a or m.

You may need to double-check the mapping and named range.

Query 3: I have some fields that can't be mapped to the existing fields

e.g. a field containing a Regional Manager name. I would like to
create some additional fields for the imported data. How do I do this?

Not possible without custom code or a third-party tool. See http://www.outlookcode.com/d/customimport.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx