Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro tweaking
good afternoon,
i have most of my macro written (Office 2007,) but am having a small issue with the following line: 'Sub Email() - sends a copy of the email to the recipients ActiveWorkbook.SendMail " 'End Sub Email() i cannot get more than one email address into the recipients list without getting some sort of an error. how would i add more than one recipient to the list. i have tried commas, semi-colons, and the "&" symbol between the email addresses. any other suggestions? thank you, jat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro tweaking
You need to pass an array in as the Recipients parameter. Either of the
following will work: Dim Recip As Variant Recip = ", ") ThisWorkbook.SendMail Recip, "Subject Goes Here" ' OR Dim Recip As Variant Dim S As String S = " Recip = Split(S, ";") ThisWorkbook.SendMail Recip, "Subject Goes Here" -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "jatman" wrote in message ... good afternoon, i have most of my macro written (Office 2007,) but am having a small issue with the following line: 'Sub Email() - sends a copy of the email to the recipients ActiveWorkbook.SendMail " 'End Sub Email() i cannot get more than one email address into the recipients list without getting some sort of an error. how would i add more than one recipient to the list. i have tried commas, semi-colons, and the "&" symbol between the email addresses. any other suggestions? thank you, jat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Tweaking formula? | Excel Discussion (Misc queries) | |||
Golf Score Formula needs tweaking | Excel Discussion (Misc queries) | |||
"AutoPrint" type macro requires tweaking | Excel Discussion (Misc queries) |