|
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 |
Excel Files to be sent out via Lotus Notes
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 |
Excel Files to be sent out via Lotus Notes
Fo the OP
See also http://www.excelkb.com/?cNode=1X5M7A -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jacob Skaria" wrote in message ... 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 |
Excel Files to be sent out via Lotus Notes
Thanks Ron..
If this post helps click Yes --------------- Jacob Skaria "Ron de Bruin" wrote: Fo the OP See also http://www.excelkb.com/?cNode=1X5M7A -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jacob Skaria" wrote in message ... 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 |
| All times are GMT +1. The time now is 06:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com