Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email Question
I am using Excel 2007. I have a list of names in column A and email
addresses in column B. I want to create a macro or something that will allow me to click on a hyperlink (or button) and it puts all the email addresses into on email so i can do a mass email. I will be adding names to the list so I want it to update it everytime you click on it. ALso can you click on it and it asks what names you want the email to go to? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email Question
have a look at
http://www.rondebruin.nl/sendmail.htm There should be something to help you -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "John" wrote: I am using Excel 2007. I have a list of names in column A and email addresses in column B. I want to create a macro or something that will allow me to click on a hyperlink (or button) and it puts all the email addresses into on email so i can do a mass email. I will be adding names to the list so I want it to update it everytime you click on it. ALso can you click on it and it asks what names you want the email to go to? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email Question
Unfortunately, I actually dont want to send the workbook or a worksheet. I
just want to create an email with the names from the cells. "John" wrote: have a look at http://www.rondebruin.nl/sendmail.htm There should be something to help you -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "John" wrote: I am using Excel 2007. I have a list of names in column A and email addresses in column B. I want to create a macro or something that will allow me to click on a hyperlink (or button) and it puts all the email addresses into on email so i can do a mass email. I will be adding names to the list so I want it to update it everytime you click on it. ALso can you click on it and it asks what names you want the email to go to? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email Question
There is information on my site to do this
Click also on the Tip link on each page to get more help See this section on my mail page Outlook object model (body) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... Unfortunately, I actually dont want to send the workbook or a worksheet. I just want to create an email with the names from the cells. "John" wrote: have a look at http://www.rondebruin.nl/sendmail.htm There should be something to help you -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "John" wrote: I am using Excel 2007. I have a list of names in column A and email addresses in column B. I want to create a macro or something that will allow me to click on a hyperlink (or button) and it puts all the email addresses into on email so i can do a mass email. I will be adding names to the list so I want it to update it everytime you click on it. ALso can you click on it and it asks what names you want the email to go to? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Email Question
Hi
I thought this one would do what you want http://www.rondebruin.nl/mail/folder3/message.htm -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "John" wrote: Unfortunately, I actually dont want to send the workbook or a worksheet. I just want to create an email with the names from the cells. "John" wrote: have a look at http://www.rondebruin.nl/sendmail.htm There should be something to help you -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "John" wrote: I am using Excel 2007. I have a list of names in column A and email addresses in column B. I want to create a macro or something that will allow me to click on a hyperlink (or button) and it puts all the email addresses into on email so i can do a mass email. I will be adding names to the list so I want it to update it everytime you click on it. ALso can you click on it and it asks what names you want the email to go to? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open email reply to previous question | Excel Discussion (Misc queries) | |||
Email from Excel - 2 Part Question | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel |