Crossposted to more Excel groups
For my mail page : http://www.rondebruin.nl/sendmail.htm
I create a new sheet template for Excel/Outlook 2007 and 2010 and I am looking for testers.
After you install the
template (xltm) you can right click on the sheet tabs and choose Insert to Insert the worksheet to the
Because you will save this worksheet in the workbook it is very easy to send one or more mails with one click on a button
You can send one sheet or more or the whole workbook on only a few text lines. And you can create one mail or many.
Note: You use one row for each mail that you want to create and in the fields Sheets, To, CC, BCC and Body text you use Alt
for example every worksheet name so each sheet name is on a new line in the cell.
In the sheet there is a Table
with the following fields
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 tips when you select a cell.
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.
File Name: Enter the prefix
for the file name (date/time and extension will add automatic)
Values: to convert formulas to values
Objects: to delete all objects
To: Enter the mail addresses here separated with alt Enter
the mail addresses here separated with alt Enter
BCC: Enter the mail addresses here separated with alt Enter
Subject: enter the mail subject here
Attach other files: You can use a button to select the files you want
to attach to the mail
Body text: Enter a short body text and separate every line with Alt Enter
want to test this sheet template you can mail me private and I will mail you the file.
Thank you very much