Excel List of Email Addresses

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.

Hi Jenny,

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

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


---
Regards,
Norman



"Jenny" <jwilliams644@hotmail.nospam.com> wrote in message
news:O3vEYidfGHA.2208@TK2MSFTNGP05.phx.gbl...
> 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.
>

Hi Jenny,

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

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


---
Regards,
Norman



"Jenny" <jwilliams644@hotmail.nospam.com> wrote in message
news:O3vEYidfGHA.2208@TK2MSFTNGP05.phx.gbl...
> 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.
>

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.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"Jenny" <jwilliams644@hotmail.nospam.com> wrote in message
news:O3vEYidfGHA.2208@TK2MSFTNGP05.phx.gbl...
> 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.
>