Thread: SendMail to multiple recipients, one variable, and one constant
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default SendMail to multiple recipients, one variable, and one constant
This is working for me with the address in A1

Dim myRecipient As String
myRecipient = Sheets("Sheet1").Range("A1").Value
ActiveWorkbook.SendMail Recipients:=Array(myRecipient, "), Subject:=("Assignments for ")



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Craig" wrote in message oups.com...
I'm trying to use the SendMail command to send a workbook to two
people, one manager, and one employee, the employee is variable, but
the manager is constant, here's what i have right now

ActiveWorkbook.SendMail Recipients:=Array(myRecipient ,
") Subject:=("Assignments for " & myJob)

that current line is looking for an end of statement, so i'm sure i've
formatted something wrong, but everything i try will send the email to
myRecipient, but not , any ideas?



Reply With QuoteReply With Quote