sending e-mail with a excel 97 macro

[darronb]

I have a macro which will e-mail an Excel spreadsheet.
I am using the line:-

Application.Dialogs(xlDialogSendMail).Show

I know there are arguments you can add to the end such as e-mail address, subject line.

can anyone advice me on the way to do this, i need to include "E-Mail Group", "Subject Line", and "Message"

If anyone has a list of all the arguments that would be great

Thanks.

 

[Gavona]

From help:

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.


Gavin