send mail with a body, using DialogSendMaill

[leeds]

Hi,

I would like to know if it's possible to send my mail by using lotus with a text body via the macro below,

Application.Dialogs(xlDialogSendMail).Show _
arg1:=recipient, _
arg2:=" subject" & RegionToGet

For the moment the mails I can send to each of the recipient are composed only by different file, but I still can't add a body. Moreover I've seen on the net that there ara many problems with this application but maybe someone have a solution to avoid the problem or just solve it.


Many thanks !!

 

[Andrew Poulsom]

Welcome to MrExcel.

SendMail doesn't allow for a body, but there is some code for Lotus Notes here that you may be able to adapt:

http://www.rondebruin.nl/notes.htm