SendMail and BCC

  • Thread starter Thread starter Darrin Henry
  • Start date Start date
D

Darrin Henry

Is it possible to use SendMail and specify one person as the recipient
and someone else as bcc? The workbook is being sent as an attachment, as
for now I have this:
ActiveWorkbook.SendMail _
Array("(e-mail address removed)", "(e-mail address removed)"), ""

It will work, however, I wish that the second recipient would be bcc'd
instead of a regular recipient? Is this possible or is there another way
of doing this?
 
This doesn't appear to be supported, but you could just send it twice. Less
than ideal, I know, but better than nothing (I hope).
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com
 
Back
Top