Try this:

ActiveWorkbook.SendMail _
", _
Subject:="Subject header" & Format(Date, "dd/mmm/yy")

"nbaj2k" wrote:


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