Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / November 2004

Tip: Looking for answers? Try searching our database.

how to import an email list to excel from word to outlook

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
excel to outlook - 21 Nov 2004 04:26 GMT
I am trying to get an email list into my outlook without having to copy and
paste a hundred emails. I think I should be able to do it thru excel. If
anyone can help please email
Dave Peterson - 21 Nov 2004 15:10 GMT
Is your list in excel (one row per entry)??

If yes, maybe you could save it as a comma separated values file (.csv) and then
import it into outlook's contacts.

> I am trying to get an email list into my outlook without having to copy and
> paste a hundred emails. I think I should be able to do it thru excel. If
> anyone can help please email

Signature

Dave Peterson

Gord Dibben - 21 Nov 2004 18:41 GMT
The basics........Your layout may differ.  Instructions here are for Name and
Email address only, but adjust to suit for more columns.

First have the names and email addresses in Excel in two columns.

I set up also a third column with the names duplicated so when you Import to
Outlook you have a name for the Contact and a Display Name instead of the
email address in the To: box.

File>Save As>File Type CSV(comma delimited)(*.csv)

Now open Outlook and File>Import>Export>Import from another file>Comma
Separated Values(Windows)>Next>File to Import(you can browse to your saved
*.csv file).  Next you will be asked where to import them to.  I bring mine to
"Contacts".

Follow the instructions and you will get a Map.  Drag your names and addresses
to the appropriate spots on the Map

1.  Name of Contact
2.  Email address1
3.  Display Name(if you have one by making the duplicate column mentioned
earlier).  If not, the email address wil be displayed in the To: box.

Continue with the OK's until Outlook pulls all from the *.csv file(should take
only a few seconds).

Now they are in the Contacts folder, you can group them as you wish.

Gord Dibben Excel MVP

>I am trying to get an email list into my outlook without having to copy and
>paste a hundred emails. I think I should be able to do it thru excel. If
>anyone can help please email
Babs - 23 Nov 2004 18:09 GMT
Use your address book

> I am trying to get an email list into my outlook without having to copy and
> paste a hundred emails. I think I should be able to do it thru excel. If
> anyone can help please email
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.