Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send worksheet as HTML email | Excel Discussion (Misc queries) | |||
Macro to send worksheet via email | Excel Discussion (Misc queries) | |||
send excel worksheet using email | Excel Discussion (Misc queries) | |||
Send an email to a list of emails in a worksheet | New Users to Excel | |||
Send worksheet via email this spreadsheet button | Excel Programming |