Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sending to a group name error
I will be grateful for any help on the following. I have a short macro that
sends an email message; the receipients address is held in a cell = s_Config.Range("Config_Email") When the receipient is a single address this works fine, but if it is sent to a group name;ie, several different people, then it errors out but usually the message is actually sent I show below the code I am using ESubject = Successful" Sendto = s_Config.Range("Config_Email") EBody = "Operation is successful" Set App = CreateObject("Outlook.Application") Set Itm = App.CreateItem(0) With Itm .Subject = ESubject .To = Sendto .Importance = 2 .Body = EBody .send End With Set App = Nothing -- with kind regards Spike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending a group email | Excel Worksheet Functions | |||
Getting #name? error in cells after sending spreadsheet via email | Excel Worksheet Functions | |||
error sending email (as attachment) from within Excel 2000 | Excel Discussion (Misc queries) | |||
Error in Sending Email via CDO | Excel Programming | |||
Sending Email using CDO ERROR | Excel Programming |