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:="Name@mail.com", Subject:="Test File"

End Sub

Chris