Excel List of Email Addresses

[Jenny]

Hi - I have a single-column list of about 200 email addresses for our club.
I need to send a simple text email to all of them, using Outlook Express
(1st choice) or Outlook. Is there an easy way to convert this list of
addresses into a format that OE will recognize, without copying and pasting
them individually? If not, any suggestions for a Plan B? Thanks very much
for your help, Jenny.

 

[Norman Jones]

Hi Jenny,

Ron de Bruin has sample code which you should be able to adapt to your
needs:

http://www.rondebruin.nl/sendmail.htm

 

[Arvi Laanemets]

Hi

Use Word Mail Merge with Excel workbook as source table. As all messages are
same, then simply enter the message text into MM document. After that, start
mail merge, select e-mail as output media, and estimate mail addresses
column as address, when asked. The same mail is sent to every member of
address list.