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 do i import excel address files to outlook
I have made a mailing label sheet in word, and imported it into excel. I
want to put the addresses and contacts in outlook contacts. I have used the import export function in outlook, but the details are coming in in seperate entries, ie address as one contact town as another. I used the map customs fields and dragged each line onto the right place but i still wont put all details in one contact. I even tried editing the excel addresses onto one cell, but it still does same thing |
#2
|
|||
|
|||
how do i import excel address files to outlook
#1) First line (row) in worksheet contains one column for each element of
your address (name, city etc) #2) Your data follows with one line per address - data in the appropriate columns #3) Set you "Named Range" to encompass BOTH your header row and ALL data rows. If you're not familiar with "Named Ranges" and don't want to bother with this - save the worksheet as a CSV file. #4) Import your file (XLS or CSV whichever you decided to go with) via Outlook as before. Karl __________________________________________________ ___________ ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2003" http://www.contactgenie.com "deb999" wrote in message ... I have made a mailing label sheet in word, and imported it into excel. I want to put the addresses and contacts in outlook contacts. I have used the import export function in outlook, but the details are coming in in seperate entries, ie address as one contact town as another. I used the map customs fields and dragged each line onto the right place but i still wont put all details in one contact. I even tried editing the excel addresses onto one cell, but it still does same thing |
Thread Tools | |
Display Modes | |
|
|