Unofficial Outlook Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Thursday, April 09, 2009 – Permalink –

Excel-lent E-Mail

Outlook, Excel, and VBA

Ron de Bruin, Microsoft MVP - Excel, has put together a collection of VBA routines to make Excel e-mail friendly.

See if these topics tempt you:

Example Code for sending mail from Excel

Mail Workbook

Mail one Sheet

Mail more than one Sheet

Mail the Selection or range

Mail Every Worksheet with Address in cell A1

Mail sheet or sheets to one or more people

Mail range or sheet in the body of the mail (Send personalized email)

Mail a message to each person in a range with Outlook

Mail a message to each person in a range with CDO (no security warnings)

Sending a different file to each person in a range with Outlook

Zip the ActiveWorkbook and mail it with Outlook

Security (Prevent displaying the dialog to Send or not Send)

Also Download Addins for Excel e-mail information
Also see:

John Walkenbach:
Sending Personalized Email from Excel

See all Topics

outlook
Labels: Addins, Macros, Tips, Tutorials, VBA

<Doug Klippert@ 3:28 AM

Comments: Post a Comment