Excel E-mail Submit button 1

[carmo]

How can you create an Excel submit button that sends the spreadsheet to an e-mail recipient. I am looking for something like the sendobject in MS - Access. Thanks.

Carmo

 

[bearnone]

The VBA script to submit an active worksheet through Microsoft Outlook is pretty easy:

ActiveWorkbook.SendMail ("Recepiants Email address&quot

Using this command, the activeworksheet is sent as an attachment with the subject of the email as the title of the active worksheet.

Problems arise on two fronts:

1. If not all users are using MS Outlook the SendMail command (originally a Unix System command) will connect with the current email system ok, but I'm not sure how the email address need to be formatted.

2. Excel 2000 displays a security alert that Excel is sending an email.

Hope that helps.