Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to send specific cell ranges to multiple e-mail addresses
I am trying to set up a macros that will allow me to send specific cell
ranges to multiple e-mail addresses. I don't have any problem setting up the first cell range/e-mail address, but I am not sure how to set up the command for the additional ranges. Do you have any suggestions? Sub MacroTest() ' Select the range of cells on the active worksheet. ActiveSheet.Range("A1:H7", "A9:H12").Select ' Show the envelope on the ActiveWorkbook. ActiveWorkbook.EnvelopeVisible = False ' Set the optional introduction field thats adds ' some header text to the email body. It also sets ' the To and Subject lines. Finally the message ' is sent. With ActiveSheet.MailEnvelope .Introduction = "This is a sample worksheet." .Item.To = " .Item.Subject = "Test" .Item.Send End With End Sub -- Thank you, Meghan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to send email to multiple addresses | Excel Worksheet Functions | |||
How to send different ranges to multiple e-mail recipients | Excel Programming | |||
How send e-mail to a group of addresses on Excel worksheet? | Excel Discussion (Misc queries) | |||
How can I e-mail multiple persons whose addresses are in excel? | Excel Discussion (Misc queries) | |||
Editing Multiple E-Mail Addresses... | Excel Worksheet Functions |