Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Mail from Excel with Outlook (Windows)

Outlook object model (attachment)

Mail the whole workbook

Mail one sheet

Mail more then one sheet

Mail Range or Selection

Mail every worksheet with address in A1

Mail a different file(s) to each person in a range

Mail chart or chart sheet as picture

Mail a row or rows to each person in a range

Mail Sheet, Sheets, Range or workbook as PDF in Excel 2007

Zip the Active Workbook and mail it with Outlook

 

Outlook object model (body)

Mail one worksheet in the body of the mail

Mail Range/Selection in the body of the mail

Mail selection, range or worksheet in the body of a mail with MailEnvelope

Mail a small message

Mail a message to each person in a range

Mail every worksheet with address in A1 (Body)

Mail a row to each person in a range

Mail a row or rows to each person in a range

Send a mail when a cell reaches a certain value

Send mail with link to workbook

 

Other tips

Tips for the Outlook object model examples

Use the mail account you want in your mail macro

Insert Outlook Signature in mail

Save E-mail attachments to folder

Convert Excel data to Outlook Contacts

Test if Outlook is open and open Outlook with VBA