Thread: email
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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