BCC Email using a Command Button

T

Tdahlman

I have a command button in my workbook that will automatically email the file
to some designated recipients.
How can I make the email Blind Copy 2 of the recipients?
Currently every recipient shows up in the "TO" section.

Please Advise,
Thanks,
Travis
 
T

Tdahlman

I don't fully understand all that.
Here is the code that I'm using right now.

DealerEmail = Sheets("Sample Chair").Range("D14").Value

JobName = Sheets("Sample Chair").Range("D17").Value

ActiveWorkbook.SendMail Array(RSM_Email, DealerEmail, "[email protected]",
"[email protected]", "[email protected]), "Sample Chair - " & JobName

End Sub

This works perfect for sending it to everyone that I need.
But what I would like if I can is to make it so that Person2 and Person3 are
blind copied instead.
Do you know how I can alter the code that I already have?

Thanks,
Travis
 
Top