Import contact list from excel

  • Thread starter Thread starter k.roberts
  • Start date Start date
K

k.roberts

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!

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

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?


Many thanks for any help.
 
Comments inline below

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



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!
Click to expand...

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.
Click to expand...

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?
Click to expand...

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top