How to export address fields in several Excel columns to Outlook?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charlie Bamford - 03 Jan 2005 04:56 GMT

I have addresses in several columns in an Excel spreadsheet. Some columns
can easily be mapped to Outlook fields e.g. town, post code, county.
However, the remainder of the address (i.e. the first part) may be limited to
just one column or may spread over several e.g. 73 High Street (column A),
Deans (column B), Livingston (column C - town). When I import into Outlook
it is difficult to get the standard Outlook display for the first two columns.

Reply to this Message

Sue Mosher [MVP-Outlook] - 13 Jan 2005 14:33 GMT

You must have a one-to-one mapping between Excel columns and Outlook fields.
Adjust the Excel data as needed.

Signature

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

>I have addresses in several columns in an Excel spreadsheet. Some columns
> can easily be mapped to Outlook fields e.g. town, post code, county.
[quoted text clipped - 5 lines]
> it is difficult to get the standard Outlook display for the first two
> columns.

Reply to this Message