Email the excel workbook itself thru VBA

[fishie]

Hi,

I have created a form in excel that ask users to enter a few numbers and perfroms calculation and create reports. However is it possible to created a macro that when runned will create a email message and attached itself to the mail automatically, I cannot use the sendmail function since the receipent is unknow. Anyone have any ideas?.

Also I do not wish to use the toolbar function as I have hidden all the toolbars and use the full screen mode. The worksheet is also protected to prevent users edit to unnecessary cells. Any help would be appreciated.

thanks.

 

[LeighAnne]

Have you tried using dialogs ?

I.e. workbook.dialogs(xlDialogSendMail).show

This will open an a message with the workbook attached so that you can then enter the recipients.