A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do i import excel address files to outlook



 
 
Thread Tools Display Modes
  #1  
Old September 30th, 2006, 02:35 PM posted to microsoft.public.outlook.contacts
deb999
external usenet poster
 
Posts: 1
Default 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  
Old September 30th, 2006, 09:32 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.