Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  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

Labels: , , ,


<Doug Klippert@ 3:27 AM

Comments: Post a Comment