SendMail and BCC
 

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 _
", "), ""

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!

SendMail and BCC
 

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


"Darrin Henry" wrote in message
...
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 _
", "), ""

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!