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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must have a one-to-one mapping between Excel columns and Outlook fields.
Adjust the Excel data as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Contact Email Addresses 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Contacts From Excel to Outlook Not Working 3
Exporting OUtlook contact addresses into Excel 1
Sorting address fields 4
how do i import excel address files to outlook 1
How can I export the "Created" date field in contacts? 1
Exporting multipart addresses? 1

Back
Top