Hi nbaj2k

You must use the Outlook object model if you want to use CC.
Not possible with SendMail

See my site for example code (click also on the Tip link on every example page)
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"nbaj2k" wrote in message
...

I am at work and made a macro to do some simple automation of some daily
reports I have to do. Everyday I have to send this report to one person
and CC it to 3 different people. I wanted to include this in the
current Macro.

Is there some way in the code to add this so that it automatically
opens Microsoft Outlook and makes this an attachment?

Thanks,

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=562416