» 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:
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Windows XP for Dummies
- Financial Reporting and Analysis (2nd Edition)
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Business Plans For Dummies®
No comments have been submitted.
