Thread: send email with email addresses in a range of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig[_24_] Craig[_24_] is offline
external usenet poster
  
Posts: 39
Default send email with email addresses in a range of cells
I'm trying to send a workbook to a list of email addresses within the
workbook. When I use ActiveWorkbook.SendMail and list the recipients
as values of cells withing the workbook, It's coming up with a 1004,
unkown recipient name in list of recipients. How would i format the
recipient section in the vb code to get rid of this error? Or is there
a better way to do this all together (other than
ActiveWorkbook.SendMail?

Reply With QuoteReply With Quote