Application.Dialogs(xlDialogSendMail).Show

[Guest]

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

 

[Leith Ross]

Hello James,

Here is a URL that will walk you through the process of adding in what
you want. The problem many users face when sending messages with OE is
the message size is only 240 characters. This site shows you the work
around and explains everything clearly and in detail.

Have a look here at
http://vbnet.mvps.org/index.html?code/internet/shellexecutelargeemail.htm

Sincerely,
Leith Ross