automate sending excel spreadsheet

Posted by Elizabeth on September 18, 2001 10:45 AM

I need to automate sending an excel spreadsheet. The user wants a button for each customer that will send the spreadsheet to the specific customer.

Posted by Tom Morales on September 18, 2001 11:21 AM

Elizabeth -
Look Up the "SendMail" method in VBA Help. It has the example line of VBA code:

ActiveWorkbook.SendMail recipients:="Jean Selva"

You'll need to attach a macro to each button with the appropriate recipient in the macro. You can put in the client's whole email address in the quotation marks. Have fun.
Tom