If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to export address fields in several Excel columns to Outlook?
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. |
#2
|
|||
|
|||
You must have a one-to-one mapping between Excel columns and Outlook fields.
Adjust the Excel data as needed. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Charlie Bamford" Charlie wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Exporting a range of cells in Excel to Outlook 2003 | DennisF | Contacts | 8 | July 22nd, 2004 08:36 AM |
EXCEL TO OUTLLOK | Woodsmith | General Discussion | 0 | July 6th, 2004 12:29 AM |
export 1 query 5 times to 1 excel file | Mike_Walrus | Running & Setting Up Queries | 7 | June 20th, 2004 01:09 AM |
Outlook error after moving from Outlook 2003 to Outlook 2002 | Navin | Installation & Setup | 0 | May 13th, 2004 01:51 PM |