Is it possible to write a macro that emails a specific person a spreadsheet when run?

Posted by Nathan Lemieux on March 02, 2001 1:59 AM

I need to write a macro to email a report I compile to a specific outlook recipient. The best I can do is to get the send mail dialog box to pop up. Please help me. Thanks

Nathan Lemieux

Posted by Roger Redhat on March 04, 2001 12:04 PM

Nathan,
How about this code:-

Worksheets("YourReportName").Copy
ActiveWorkbook.SendMail "anyone@anywhere.com"

Regards,
Roger.