Macro to run on Open

[Jim]

I have a macro that will add an attachment to the current Outlook message,
but I can't figure out how to get the macro to run automatically when the
message is opened. The message is a template (.oft). I'm new to Outlook
macros, can anyone help?

Thanks,
Jim

 

[Michael Bauer [MVP - Outlook]]

Jim, see the NewInspector event.

--
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 Fri, 25 Sep 2009 11:43:01 -0700 schrieb Jim:

 

[Sue Mosher [MVP]]

That requires an event handler, not a macro. Since you're new to VBA, I
would suggest that you stick to the macro approach and write one that starts
by loading the .oft file:

Sub MyMacro
Dim newItem as Outlook.MailItem
Set newItem = Application.CreateItem("C:\my template.oft")
newItem.Attachments.Add "C:\myfile.doc"
newItem.Display
End Sub

That will probably save you the step of locating the .oft file.