Excel Macro

Posted by Louise on November 14, 2001 7:05 PM

Dear Mr. Excel,
I would like to develop a Macro when I change to today date, and it will send the whole document to A,B,C persons. At this right time, I can make the email messager pop up, but it won't automatically add the A,B,C's email address in the receipant's box. could you teach me how to make this????

Posted by Dank on November 15, 2001 4:15 AM

Louise,
The code to send the active workbook to email recipients is:-

Sub SendActiveWorkbook()
Dim SendToWho
SendToWho = Array("john@somewhere.com", "dave@hotmail.com", "rod@hull.co.uk")
ActiveWorkbook.SendMail SendToWho, "Subject text"
End Sub

Hope it helps,
Dan.