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?