Excel Files to be sent out via Lotus Notes

  • Thread starter Thread starter Elton Law
  • Start date Start date
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
 
Back
Top