MrExcel Publishing
Your One Stop for Excel Tips & Solutions

e-mail macro

Posted by Boel on January 31, 2002 11:35 PM

please help! I'm trying to record a macro that will send a workbook by email to a specific address by clicking a button. I record the macro but then when I push the button outlook opens without the e-mail address I specified in the macro and no mail is beeing sent. What do I do wrong?

Posted by Tom Morales on February 01, 2002 4:51 AM

Boel - Recording macro's doesn't work across applications. You'll have to write some code. The good news is that what you want is simple. Look up the "SendMail" method in Excel VBA help. That will show you how to send a workbook to a particular address.