Read this first

Note: This sheet template is also a part of this add-in for Excel 2007-2010 with
Outlook Express, Windows Mail and Windows Live Mail.
http://www.rondebruin.nl/mail/add-in.htm

Tip: If you use Microsoft Outlook check out this two pages for different templates with much more options:

Outlook Mail Worksheet Template for Excel 2007-2010
http://www.rondebruin.nl/mail/outlooksheettemplate.htm

Outlook Mail PDF Worksheet Template for Excel 2007-2010
http://www.rondebruin.nl/mail/outlooksheettemplatepdf.htm

Note: If you not use Excel 2007-2010 visit my mail template page for another version.
http://www.rondebruin.nl/mail/templates.htm



RDBMail Worksheet Template for Excel 2007-2010 with OE-WM-WLM

Download Install file (version 2.0)

First Unzip the xlsm file on your desktop.
When you open the xlsm file it will automatic install the sheet template in the correct folder for you.


After you installed the Template you can :

Right click on any worksheet tab in every workbook you want and choose Insert.
Select "RDBMail Div.xlt" and press OK to insert the worksheet in your workbook.

In the RDBMailDiv worksheet there is a Table with the following fields.
You will use one row in the Table for each mail you want to create

Send: yes or no
Sheets: Enter the sheet names you want to mail separated with Alt Enter or enter "workbook"
              if you want to send the whole workbook without the RDBMailOutlook worksheet.
File Name: Enter the prefix for the file name (date/time and extension will add automatic)
Values: Enter yes to convert formulas to values
Objects: Enter yes to delete all objects
To: Enter the mail addresses here separated with Alt Enter
Note: if you use Windows Live Mail the address must exist in your contacts.
Subject: Enter the mail subject here

Note: because it is a Table you can enter "yes" in column A on a new row and the
new row will have a nice format and the data validation when you select a cell in the new row.

Read the Data validation tips good when you select a cell in the "RDBMailDiv" worksheet.


What is Alt-Enter ?

You see that if you want to enter more then one sheet or mail address you must
seperate each entry with Alt Enter so it will be on a new line in the Cell.

If you want to send for example three worksheets you do this

1: Select cell in Sheets column
2: If needed press the delete button to clear the cell first
3: Enter the first sheet name
4: Press Alt Enter
5: Enter the second sheet name
6: Press Alt Enter
7: Enter the third sheet name
8: Press Enter

Now you see each sheet name on his own line in the cell