E-mail from within excel

[dhaywood]

I have created an excel spreadsheet, and with the use of a button or macro I want to e-mail the spreadsheet and its current contects to a set distribution list in outlook, preferable without user input.

Thanks

 

[MANJUBHAVANA]

For this first you need to create a distribution list in your outlook, then creat a button on your excel worksheet and assign it a macro for sending the worksheet to a group of people The macro should be created beforehand.

 

[sdraper]

You could record a macro but it wouldn't record the recipient info or anything else you added to the email message once it appeared.
Here is the Excel help info on the sendmail method
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.
here is an example of sendmail:
ActiveWorkbook.SendMail recipients:="Jean Selva"
hope this helps!
sdraper