| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail über Lotus Notes aus Excel heraus/ Sending Mail with Excel through Lotus Notes | Excel Programming | |||
| Lotus Notes Doc link in Excel?? | Excel Programming | |||
| Importing CSV or XLS files into Lotus Notes Calendar | Excel Discussion (Misc queries) | |||
| Excel/Lotus Notes | Excel Programming | |||
| Emailing Lotus Notes From Excel | Excel Programming | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
