Click on the link to the Tip page that you find on each example page.
There is a example there to do what you want

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Alan" wrote in message ...
Sorry, I forgot to mention, if possible I would like to put all those
addresses into the BCC field and he can put just me into the Send To field.
I doubt that that many people, a lot of them we don't even know would
appreciate their email addresses being made public,
Regards,
Alan.
"Alan" wrote in message
...
Hi Ron,
I also want to do this, I'm not a spammer, my son has raised some money
for Menengitis UK by doing a mountain climb. When he's done it he wants to
send an email to all the contributors thanking them with pictures etc.
He's used the http://www.justgiving.com/ web site to handle the donations,
so I can copy and paste all the addresses, (about two hundred of them I
think by the time it's finished) into Excel or Word, but how to put all
the addresses into one email without doing them one by one?
I have no problem with macro's,
Regards,
Alan.
"Ron de Bruin" wrote in message
...
Do you want to use a macro ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"JP" wrote in message
...
I am trying to email multiple email addresses that are in a work sheet. I
know that I can click the address once and I will be able to email that
one address, however, if I wanted to send the same email to different
addresses within different cell, how would I go about doing that?

__________ Information from ESET Smart Security, version of virus
signature database 3949 (20090319) __________

The message was checked by ESET Smart Security.

http://www.eset.com



__________ Information from ESET Smart Security, version of virus
signature database 3949 (20090319) __________

The message was checked by ESET Smart Security.

http://www.eset.com






__________ Information from ESET Smart Security, version of virus signature database 3950 (20090320) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3950 (20090320) __________

The message was checked by ESET Smart Security.

http://www.eset.com