Send Worksheet in Email
I have a worksheet called Report that I want to send in an email
automatically when the workbook is opened and data is retrieved. the commmand to send the worksheet will come after some other vb. THe email program we use is Lotus Notes Question. How do I program the worksheet to be sent using code and how would I add a subject line and message as well as a send to address Thanks |
Send Worksheet in Email
Hi Nigel
I can't help you with Lotus but my CDO code will work also http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Nigel" wrote in message ... I have a worksheet called Report that I want to send in an email automatically when the workbook is opened and data is retrieved. the commmand to send the worksheet will come after some other vb. THe email program we use is Lotus Notes Question. How do I program the worksheet to be sent using code and how would I add a subject line and message as well as a send to address Thanks |
All times are GMT +1. The time now is 04:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com