Save Email message as HTML file on Harddrive
Absolute Beginnerīs Guide to Microsoft Office Outlook 2003, by Ken Slovak
Microsoft Outlook Programming, by Sue Mosher
Application Development with Outlook 2002, by Randy Byrne
--
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.
|