MrExcel Publishing
Your One Stop for Excel Tips & Solutions

send the current sheet as message body

Posted by Dave on June 16, 2001 12:24 AM

i'm trying to figure out a macro for how to send an excel worksheet or preferably the whole workbook as the message body as it does when you click file>send to>mail recipient. i'd like the user to click a button to send it this way. any suggestions would be most appreciated.

Posted by Malc on June 16, 2001 2:39 AM

Do exactly that with the macro recorder on. You'll end up with something like

or you could type in sendmail select it and F1 to get the exact syntax. Activeworkbook.sendmail("address@???.net') will fire the email off providing you have the right address otherwise you run the risk of clogging up the mail system (i've done it) use help to get the exact syntax