Email Question

J

John

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?
 
J

John

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.
 
R

Ron de Bruin

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)
 
Top