Below are few of the links which I used sometime back. This should help...

http://www.ozgrid.com/forum/showthread.php?t=25809
http://en.allexperts.com/q/Using-Lot...otus-Notes.htm
http://www.fabalou.com/VBandVBA/lotusnotesmail.asp

--
If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Dear Expert,
I need to send Excel file as attachment to others.
Our office default mail is Lotus Notes 7.0.
I used macro recorder to send Excel file as attachment. Script is as follows.

Application.Dialogs(xlDialogSendMail).Show

All are working good. File is attached and show up in Lotus notes.
But just wonder is it feasible to even set the recipients, mail subject in
VB script please?
If possible, allow me to type some texts saying "latest data" .. That's all.
Thanks for help,
Elton