|
email
i want to send authomatic excel files updated
i use Set objOutlook = CreateObject("Outlook.application") Set objItem = objOutlook.CreateItem(olMallitem) and so on... how can i put as objItem.body an html file or a text file? tia |
email
See example 2 for test file
http://www.rondebruin.nl/mail/folder3/smallmessage.htm with .Attachments.Add Filename you can add a html file -- Regards Ron de Bruin http://www.rondebruin.nl "MarcoPolo" wrote in message ... i want to send authomatic excel files updated i use Set objOutlook = CreateObject("Outlook.application") Set objItem = objOutlook.CreateItem(olMallitem) and so on... how can i put as objItem.body an html file or a text file? tia |
email
See example 2 for test file
Typo: Text file See also this page for sending html in the body http://www.rondebruin.nl/mail/folder3/mail2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... See example 2 for test file http://www.rondebruin.nl/mail/folder3/smallmessage.htm with .Attachments.Add Filename you can add a html file -- Regards Ron de Bruin http://www.rondebruin.nl "MarcoPolo" wrote in message ... i want to send authomatic excel files updated i use Set objOutlook = CreateObject("Outlook.application") Set objItem = objOutlook.CreateItem(olMallitem) and so on... how can i put as objItem.body an html file or a text file? tia |
email
WOW SUPER
"Ron de Bruin" ha scritto nel messaggio ... See example 2 for test file http://www.rondebruin.nl/mail/folder3/smallmessage.htm with .Attachments.Add Filename you can add a html file -- Regards Ron de Bruin http://www.rondebruin.nl "MarcoPolo" wrote in message ... i want to send authomatic excel files updated i use Set objOutlook = CreateObject("Outlook.application") Set objItem = objOutlook.CreateItem(olMallitem) and so on... how can i put as objItem.body an html file or a text file? tia |
| All times are GMT +1. The time now is 05:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com