| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
| send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel | |||
![MarcoPolo[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
