View Single Post
  #8  
Old November 17th 08, 06:05 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Save Email message as HTML file on Harddrive



Terry, recommended books a

Professional Programming Outlook 2007, Wrox Press, by Ken Slovak
Microsoft Outlook Programming, by Sue Mosher

--
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 Tue, 11 Nov 2008 19:22:00 -0800 schrieb TerryM:

That definately took care of the problem. I've noticed that the syntax

for
outlook vba is quite a bit different than say Access or Excel. What
resources or books would you suggest for a beginner like me to learn from.

Thanks for all your help.

"Michael Bauer [MVP - Outlook]" wrote:



In your code, m is a new MailItem, which is blank. If you want to save

the
e-mail passed by the rule, use myItem:

Sub saveemail(myItem As Outlook.MailItem)
myitem.SaveAs "c:\temp\New Power Indices.html", olhtml
End Sub

--
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 Tue, 11 Nov 2008 06:38:13 -0800 schrieb TerryM:

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