View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Multiple SendMail Recipients

You can setup an array of names as the recipient list

ActiveWorkbook.SendMail _
", "), _
Subject:="test"

--
HTH

Bob Phillips

"John Hutcins" wrote in message
...
Is it possible to have more than one recipient with the SendMail Method?

I know I can do this: ActiveWorkbook.SendMail
").
But I haven't figured out how to add a second email address. Is it
possible? Or do you need to use a second SendMail line?