How do you attach multiple email addresses within different cells

[JP]

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?

 

[Ron de Bruin]

Do you want to use a macro ?


--

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

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

 

[Alan]

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.

 

[Alan]

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.

 

[Ron de Bruin]

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

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.



__________ 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