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 |
All times are GMT +1. The time now is 12:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com