I would like to email an excel sheet in outlook but keep the name of the worksheet.

At the moment I make a file temp.xls and mail this to several colleagues but it would be easier for me to use the original worksheet name as I send up to 200 sheets a week, that are then filled in and returned.

As you can imagine, 200 times temp.xls is difficult to follow.

Thanx for you help,

John

Here are some examples that might help

http://www.fontstuff.com/outlook/oltut01.htm


http://support.microsoft.com/kb/161088

http://vbadud.blogspot.com/2007/04/v...-vba-mail.html

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)