MrExcel.com - Your One Stop for Excel Tips & Solutions

SENDING AN .XLS FILE TO A ROUTING RECIPIENT MACRO

Posted by MIKE K on June 11, 2001 11:11 AM

HOW DO I SEND A FILE AS AN ATTACHMENT TO A ROUTING RECIPIANT WITH OUTLOOK. BASICALLY I WANT HAVA A BUTTON, THAT WILL SEND THE CURRENT FILE IM WORKING ON AS AN ATTACHMENT TO A PREDEFINED EMAIL ADDRESS USING ROUTING. THANKS IN ADVANCE.
MIKE

Posted by Tom Morales on June 11, 2001 11:28 AM

Mike -
You should use the sendmail method. Using Excel Help's example:

Sub sender()
ActiveWorkbook.SendMail Recipients:="Jean Selva"
End Sub

Attach that macro to a button from the "forms" toolbar,and you're in business.
Tom