Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I count unique email addresses across multiple worksheets? | Excel Discussion (Misc queries) | |||
updating email addresses in cells | Excel Worksheet Functions | |||
Macro to send email to multiple addresses | Excel Worksheet Functions | |||
Finding email addresses in cells | Excel Worksheet Functions | |||
email addresses in cells | Excel Discussion (Misc queries) |