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 / General Excel Questions / December 2007

Tip: Looking for answers? Try searching our database.

How to transfer emails from excel to bulk mailer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Moving addresses from excel - 20 Dec 2007 13:52 GMT
If I have a list of email addresses in excel, how do I go about moving them
to a bulk mailer or address book to send them information?
rdwj - 20 Dec 2007 14:54 GMT
don't fully understand the question. If you want to use xls to send the
emails (ie send an xls sheet based on email adresses) you can use the
Workbook.Route functionality. More complex is to create a MAPI object of your
email program and work through that.

To just import the email addresses to for example Outlook, make sure that
the addresses are on the first sheet, with a header (ie "Email Address") and
have a second column with the relevant name (if you don't have any, use the
email address as name as well). Based on this table, use the Import function
in Outlook (other email programs have something similar). Note that Hotmail
etc can NOT import external adress books - or not as far as I know.

rdwj

> If I have a list of email addresses in excel, how do I go about moving them
> to a bulk mailer or address book to send them information?
 
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.