After you insert the mail worksheet template into your workbook you have the ability to send all or part
of it either in working format or with just the values that are shown by current data and formulas.

Each “x” in column A is the beginning of a new E-Mail, the lines between each “x” are used to create the mail.
Don't forget to fill in an "x" below the last line (it will not send the last mail if you forget it).
You can use one line to send one sheet or the workbook to one person or more lines
to send an E-mail with one or more sheets (or the whole workbook) to one or more recipients.

After you install one of the templates you can insert the template worksheet
in every workbook you want like this.

1 : Right click on one of your sheet tabs and choose insert
2 : Select <RDBMail> or <RDBMail Outlook> or <RDBMail CDO>
3 : Press OK


The example below will send three mails.

1: Ron will receive Sheet1 with the File name “FileName1” and subject “Testmail1”
2: Dave and Jelle will receive Sheet1 and Sheet2 with the File name “Filename2” and subject “Testmail2”
3: Frank will receive the whole workbook with the File name “Filename3” and subject “Testmail3”

Note: In the Outlook and CDO version you can also use CC, BCC and body text.





Note: you not see the Values and Send column in this screenshot
If you want to change the formulas to values in the workbook you send enter "yes" in the values column.
Use the same password for all worksheets in your workbook and enter this in C3 of the template sheet.
The code will unprotect / make values of the cells / protect every worksheet in the workbook you send.
But if a worksheet password is different then the value in C3 it can not make values of the formulas in the worksheet. If you enter “no” in the Send column it will not send the mail.



Download and install information


Outlook Express or Window Mail
(Excel 2000-2010, file date: 26-Oct-2007)

Download: Sheet Template for Outlook Express or Windows Mail (version 1.2)

If you use Outlook Express or Windows Mail you can disable the dialog that enables you
to send or not send the message. See http://www.rondebruin.nl/mail/prevent.htm



Outlook : With CC, BCC and body text
(Excel 2000-2003, file date: 26-Oct-2007)

Note : This version is only working if you use Outlook.
Download: Sheet Template for Outlook (version 1.2)

I use .Display instead of .Send in the code because it is faster to press the
Send button in every mail then wait till you can press OK in the security dialog
each time. (you can change it to .Send in the code if you want)

For Excel 2007-2010 I have two new versions here (workbooks and PDF's)
Outlook Mail Worksheet Template for Excel 2007-2010
http://www.rondebruin.nl/mail/outlooksheettemplate.htm



CDO ( With CC, BCC and body text ) No security warnings
(Excel 2000-2007, file date: 26-Oct-2007)

Download: Sheet Template for CDO (version 1.2)
If you use the CDO template there are no security warnings.

Look first on this page if you can use the CDO template.
http://www.rondebruin.nl/cdo.htm
Don't forget to fill in the cells G1:G3 in the template.



How do I install one of the templates

1) Download the zip file and unzip it.
2) Open the the install workbook.
3) You will see a MsgBox with the following text when the install is ready.

The template is now installed in the Template folder
You can insert the Sheet Template now in every workbook you want
1 : Right click on one of your sheet tabs and choose insert
2 : Select <RDBMail> or <RDBMail Outlook> or <RDBMail CDO>
3 : Press OK

After you press OK in this MsgBox the install file will be deleted from your computer and
you can insert the sheet template in every file you want.




How do I disable hyperlinks in Excel

If you not want that Excel automatic change the E-mail address into a link read this

In Excel 2002/2010 you have a option to turn it off

Excel 2002/2003: Tools>Options>Spelling
Excel 2007: Office button>Excel Options>Proofing
Excel 2010: File>Options>Proofing

Press the "AutoCorrect Options" Button
On the "AutoFormat As You Type" Tab
Remove Check from "Internet and network paths with hyperlinks apply as you work"
OK
OK


Or use this (is working in every Excel version)

1) After you press the enter key you can use Ctrl-Z to make it text.
2) Or start the e-mail address with a '