Display active workbook in E-mail but do NOT send 1

[wakayama]

I need to put my active workbook in an email but do not want to send it.

Using ActiveWorkbook.SendMail always sends the workbook automatically.

Thanks
Osian

 

[osx99]

This link should help

http://msdn.microsoft.com/en-us/library/ff458119(office.11).aspx

Change the .Send to .Display as mentioned in the comments

 

[DrSimon]

Osian
.Save is an alternative to .Display. I prefer it as i just leaves the email in Draft until you want to send or delete.