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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

E-mail excel attachment via Lotus Notes 0
Sending Email using Lotus Notes 1
Lotus Notes not saving e-mail to Sent folder 2
Send Mail using Lotus Notes 1
Lotus Notes CreateObject 1
Sending Excel Worksheet as PDF file with Excel 2007 3
Send Excel attachment via Lotus Notes 3
Macro - Excel to I-NOTES (Lotus Domino)? 0

Top