I am using the code:

Application.Dialogs(xlDialogSendMail).Show

To send the current sheet in an excel spreadsheet, and it is working
fantastically (using Outlook Express).

However I would like to be able to:

1) Add in a standard subject line;
2) Add in a standard body message;
3) Add in an email receiptant (the email address is in a certain cell in the
spreadsheet).

Can anyone give me some feedback on how I can add to the VBA I already have?

Regards

James