» Mail the Activeworkbook using VBA in Microsoft Excel
VBA macro tip contributed by Ron de Bruin, Microsoft MVP - Excel
CATEGORY - Mail - Send and Receive in VBA
VERSION - All Microsoft Excel Versions
Sub Mail_workbook()
ActiveWorkbook.SendMail "ron@debruin.nl", _
"This is the Subject line"
End Sub
If you want to mail the workbook where the code is placed you must use the following line:
ThisWorkbook.SendMail "ron@debruin.nl", _Note: It doesn't have to be the active workbook used at that time.
Book Store:
Recommended Books:
- Special Edition Using Microsoft Office XP
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Investing in Real Estate, Fourth Edition
- Accounting for Dummies
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Windows XP Inside Out
No comments have been submitted.
