MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Send workbooks over the net

Posted by Ricardo on September 08, 1999 8:12 AM

How can I send workbooks over the net, with a macro? I have the addresses on a sheet.

Posted by Chris on September 08, 1999 8:43 AM

Here's the code to send the active workbook:

Sub asdf()

ActiveWorkbook.SendMail Recipients:="", Subject:="Test File"

End Sub