Microsoft Excel
Back to jkp-ads.com

Ron de Bruin
Excel Automation

Microsoft MVP Program

Mail from Excel with Outlook (Windows)

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse


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 range as picture in the body of Outlook mail

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