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("(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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top