Excel Files to be sent out via Lotus Notes

E

Elton Law

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
 
Top