How can you create an Excel submit

[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

 

[bryanbayfield]

Why don't you just customise your toolbar so that "Send to Mail Recipient (As Attachment)" is added to it?

If you code it in VBA all you'll be doing is replicating existing Excel functionality >> waste of time.

 

[carmo]

Because I would like to specify the default values without the user doing it (i.e subject, to, cc, etc..)

 

[Nikita6003]

From xl help:

Sends the workbook by using the installed mail system.

Syntax

expression.SendMail(Recipients, Subject, ReturnReceipt)

expression   Required. An expression that returns a Workbook object.

Recipients   Required Variant. Specifies the name of the recipient as text, or as an array of text strings if there are multiple recipients. At least one recipient must be specified, and all recipients are added as To recipients.

Subject   Optional Variant. Specifies the subject of the message. If this argument is omitted, the document name is used.

ReturnReceipt   Optional Variant. True to request a return receipt. False to not request a return receipt. The default value is False.

Remarks

Use the SendMail method in Microsoft Mail (MAPI or Microsoft Mail for the Macintosh) e-mail systems. Pass addressing information as parameters.

Plz note: the Senmail object is kind of limited; if you need to specify more detaild info you're better off using the Outlook App object.

Let us know if you need more info

Cheers
Nikki

 

[carmo]

Thanks Nikki, although we use Netscape Messenger......do you see any problems with this?

Carmo

 

[Nikita6003]

well, SendMail uses MAPI - don't think that's what Netscape uses.

Can't look into this here (no Netscape) - but I'll take a butcher's when I'm home

Cheers!
Nikki