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


What Does the SendMail Add-in Do?

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.

Thanks to Norman Harker and Dave Peterson for their contribution in this Add-ins.
I am very grateful for their help.
 
There are a few different versions of the SendMail add-in
Below are the screenshots of the Outlook add-in for Excel 2007


 

This are the options in the add-in for Outlook users





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, click 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


Excel 97-2003

SendMail Add-in version 2.3
For Office 97-2003 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, only for 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



Excel 2007
 
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



SendMail Outlook Add-in for Excel 2007: version 1.0
For Office 2007, only for Outlook

The Outlook Add-in have a few more options:
Sending the sheet or selection in the body of the mail and Zipping(WinZip) the file you send.

There is also an option to send as PDF if you install the MS PDF add-in.
Download the MS PDF add-in here.
2007 Microsoft Office Add-in: Microsoft Save as PDF

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, 15-Nov-2006)
There is a option to open the Add-in in the Office Button>Send menu or use the shortcut Alt fds



Legal Stuff

The utility's are distributed freely and with maximum exclusion of liability permitted by law.
Further distribution is permitted subject to:

1. Such distribution not being directly or indirectly for gain or reward, and
2. Distribution being together with these notes, and
3. Appropriate and prominent attribution to Ron de Bruin.

Copyright on VBA coding and techniques used to create this program is specifically retained.
Use of this program is subject to the restriction that there should be no access to or copying
of the VBA Project that forms part of the workbook without consent of Ron de Bruin and
use of a password provided only by them for that purpose.


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