Thread: Excel Files to be sent out via Lotus Notes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
  
Posts: 173
Default Excel Files to be sent out via Lotus Notes
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

Reply With QuoteReply With Quote