SendMail and BCC

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("[email protected]", "[email protected]"), ""

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?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
F

Frank Isaacs

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
 
Top