View Single Post
  #4  
Old November 11th 08, 02:38 PM posted to microsoft.public.outlook.program_vba
TerryM
external usenet poster
 
Posts: 8
Default Save Email message as HTML file on Harddrive

Ok, I figured out what I was doing wrong in regards to the SaveAs Method.
The syntax is different than in Access and Excel. I have been able to save a
file with with a predetermined name to the harddrive. The Message body is
blank however, what code am I missing to select and save the message body
also?

Here is the code listed below:

Sub saveemail(myItem As Outlook.MailItem)
Dim m As MailItem
Set m = CreateItem(olMailItem)
m.SaveAs "c:\temp\New Power Indices.html", olhtml
End Sub

"Michael Bauer [MVP - Outlook]" wrote:



Simply call the item's Save method. There should be an example in the VBA
help file.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Wed, 5 Nov 2008 08:28:00 -0800 schrieb TerryM:

I've seen quite a few questions asking this on the web, however I have not
seen an answer to it.

I am trying to create an outlook rule that will run on these criterias,
By sender--Easily done in the Outlook rule
By Subject--Easily done in the Outlook rule
run as script--Saves email message as either text or Html to a harddrive.
From there I will do an import into either excel or access to get the
information i need.

So basically what I am trying to find is the script to save the email
message (no attachments) to a hard drive.


Ads