Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Mail Add-ins for Excel for Windows

RDBMail Add-in for Excel/Outlook 2007-2016

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 for Outlook (version 3.01, File date 25-Oct-2015)

How to 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-2016: 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.

 

 

RDBMail Add-in for Excel 2007-2013 with OE, Windows Mail and WLM

If you use the Outlook version above you have more options but if you can't use Outlook you can use this version for Outlook Express, Windows Mail and Windows Live Mail together with Excel 2007-2013.

You can't send as PDF files in this version and also there is no option to send the selection or active sheet in the body of the mail.

Download the RDBMail add-in (version 2.01, File date 29-Sept-2010)

 

 

SendMail Add-in for Excel 97-2003

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.

Note : There are two different versions of the SendMail add-in.
Below are the screenshots of the Outlook add-in for Excel 2000-2003

This are the options in the Add-in for Outlook

How to Install the SendMail utility

1. Download and extract it to a local directory.

2. Copy SendMail.xla 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.

Downloads for Excel 97-2003

Important : If you use this add-in in Vista/Windows 7/8 be sure that you change the Save folder the first time you open the add-in. The save path is set to C:\ by default and that is a protected area in Vista  or Windows 7/8. 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 to that folder.

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

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

Download User guide (made by Norman Harker) PDF document

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

This Outlook Add-in have a few more options then version 2.
For example you have a option to send a sheet or selection in the body of the mail.

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) PDF document

 

Acknowledgements

Thanks to Norman Harker and Dave Peterson for their contribution in this Add-ins.