» 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 Access 2002
- Microsoft PowerPoint Version 2002 Step by Step
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Monte Carlo Methods in Finance
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
No comments have been submitted.
