Excel 2007 VBA Programming with XML and ASP

Chapter 22Chapter 22

Printing and

Sending E-mail

from Excel

Controlling the Page Setup + Controlling the Settings on

the Page Layout Tab + Controlling the Settings on the

Margins Tab + Controlling the Settings on the

Header/Footer Tab + Controlling the Settings on the Sheet

Tab + Retrieving Current Values from the Page Setup

Dialog Box + Previewing a Worksheet + Changing the

Active Printer + Printing a Worksheet + Disabling Print-

ing and Print Previewing + Using Printing Events +

Sending E-mail from Excel + Sending E-mail Using the

SendMail Method + Sending E-mail Using the MsoEnve-

lope Object + Sending Bulk E-mail from Excel via Outlook

+ Chapter Summar ...