» 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:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Windows XP Registry Guide
- The Interpretation of Financial Statements
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Dictionary of Finance and Investment Terms
- Accounting and Financial Fundamentals for Nonfinancial Executives
No comments have been submitted.
