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!

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!