Combine Excel and Outlook

"The subs will send a newly created workbook with just the visible cells in the selection or range.

The cells will be PasteSpecial as values in the workbook you send. 

It saves the workbook before mailing it with a date/time stamp. 

After the file is sent, the workbook will be deleted from your hard disk."

Labels: General, Reference, Tips, Tutorials