If you are looking for VBA code examples then go to my mail code page
http://www.rondebruin.nl/sendmail.htm

Note : Download the correct add-in on this page for your Excel version and mail program.


RDBMail Add-in for Excel/Outlook 2007-2010

Note: I changed the name of this new add-in for Excel/Outlook 2007-2010 to RDBMail.
The older add-ins are all named SendMail.

Briefly! RDBMail puts emailing of Excel sheets, data, and workbooks where you want it and
when you want it (as Workbook or PDF). It also allows significant customizing of what you send.
As soon as you have the workbook open in Excel 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.
Once RDBMail has been installed, this is all accessed by clicking on one of the options on the
RDBMail tab on the Ribbon.

On the RDBMail tab on the Ribbon you can find the following mail options :



Also new in this add-in is that there are two options to Insert a worksheet template to your workbook.
Click on the Information button for more information about this two Worksheet templates.



Important : When you open the Add-in the first time I suggest you click on the Help button first
to read all the information. This is the first button in the Manual group on the RDBMail tab.


Download the RDBMail add-in  (version 2.0, File date 17-Feb-2010)


Install the RDBMail utility

1. Download and extract it to a local directory.

2. Copy RDBMail.xlam to a unprotected directory on your system.
Tip: Use one folder for all your add-ins (easy to backup your add-ins this way)

3. Start Excel and open a workbook.

4. 2007: Click the Microsoft Office Button, click Excel Options, click the Add-Ins tab.
    2010: Click on File, click on Options, click the Add-ins tab
In the Manage drop-down, choose Excel Add-ins, and click Go. Use “Browse” to go to the add-in and then
click on OK. Verify RDBMail is checked in the add-in list and then click OK.



SendMail Add-in for Excel 97-2007

Briefly! SendMail puts emailing of Excel sheets, data, and workbooks where you want it
and when you want it. It also allows significant customizing of what you send.
As soon as you have the workbook open in Excel 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.
Once SendMail has been installed, this is all accessed by clicking on SendMail in the Tools menu.
Or clicking on Office button>Send>SendMail.... in Excel 2007.

There are a few different versions of the SendMail add-in
Below are the screenshots of the Outlook add-in for Excel 200-2003

 

This are the options in the Add-in for Outlook




Install the SendMail utility

1. Download and extract it to a local directory.

2. Copy SendMail.xla(m) to a unprotected directory on your system.
Tip: Use one folder for all your add-ins (easy to backup your add-ins this way)

3. Start Excel and open a workbook.

4. (Excel 97-2003) Click Tools, click Add-Ins, use “Browse” to go to the add-in and then
click OK. Verify SendMail is checked in the add-in list and then click OK.

5. (Excel 2007) Click the Microsoft Office button, click Excel Options, click the Add-Ins tab.
In the Manage drop-down, choose Excel Add-ins, and click Go. Use “Browse” to go to the add-in and then
click on OK. Verify SendMail is checked in the add-in list and then click OK.



Downloads for Excel 97-2003

SendMail Add-in version 2.3
For Office 97-2003, working with Outlook, Outlook Express or Windows Mail

If you use this add-in in Vista be sure that you change the Save folder the first time you open the add-in.
The save path is set to C:\ and that is a protected area in Vista.
Add a folder in your Documents folder for example “C:\Users\<UserName>\Documents\Mail” and
Click on the “Customize” button on the Userform to change the path.

Download Add-in (Version 2.3, 11-Oct-2006)

Download User guide (made by Norman Harker) Word document
Download User guide (made by Norman Harker) PDF document


SendMail Add-in version 3.3
For Office 2000-2003, working only with Outlook

The Outlook Add-in have a few more options then version 2.
For example sending the sheet or selection in the body of the mail and zipping(WinZip) the file you send.

If you use this add-in in Vista be sure that you change the Save folder the first time you open the add-in.
The save path is set to C:\ and that is a protected area in Vista.
Add a folder in your Documents folder for example “C:\Users\<UserName>\Documents\Mail” and
Click on the “Customize” button on the Userform to change the path.

Download Add-in (Version 3.3, 11-Oct-2006)
Note: this Add-in is only working if you use Outlook (not Outlook Express or Windows Mail)

Download User guide (made by Norman Harker) Word document
Download User guide (made by Norman Harker) PDF document



Download for Excel 2007

Note: See the new version for Outlook on top of this page
I will upload a new version for this add-in also soon.
 
SendMail Add-in for Excel 2007 : version 1.0
For Office 2007 with Outlook, Outlook Express or Windows Mail

If you use this add-in in Vista be sure that you change the Save folder the first time you open the add-in.
The save path is set to C:\ and that is a protected area in Vista.
Add a folder in your Documents folder for example “C:\Users\<UserName>\Documents\Mail” and
Click on the “Customize” button on the Userform to change the path.

Download Add-in (Version 1.0, 10-Dec-2006)
There is a option to open the Add-in in the Office Button>Send menu or use the shortcut Alt fds



Acknowledgements

Thanks to Norman Harker and Dave Peterson for their contribution in this Add-ins.
I am very grateful for their help.


Ron de Bruin
Microsoft MVP - Excel
rondebruin@kabelfoon.nl