Macro Button (2003)

Topic

New Reply

Hi,
I would like to create a macro button in outlook to open a user template file (ie a standard email I often use). Can anyone please provide the VBA code to do this – outlook doesn’t seem to have a ‘record macro’ function like MS Word’? I believe I can create the button by using the customise|macros|select-and-drag-onto-toolbar…let me know if I have got this wrong.

Reply | Quote

Replies

Would you be OK with setting it as a Shortcut? Cobbling together MaryJ’s post 217640 and the last paragraph of post 376202, you should be able to create an Outlook 2003 shortcut directly to the template file on drive, and open it from the Outlook Shortcut.

See also post 298,905, this Crabby Office Lady tip, which should still work for office 2003, and post 308085.

Reply | Quote

Repurposing some other code, the steps you would need in your macro are along these lines:

Sub MakeMessageFromTemplate()
Dim msg As Outlook.MailItem
Set msg = CreateItemFromTemplate("c:ExactPathToFile.oft")
msg.Display
Set msg = Nothing
End Sub

Once the macro exists, you could do as you describe to make it accessible using a button.

Reply | Quote

Thanks guys – you have made my life a bit easier. I used the macro and it all worked a treat. I will try the shortcut method later in the week.

Reply | Quote

Hi there again. I work in two IT environments (Large Government Department, and a small firm). In both enviroments I have my email set up to autmatically generate my signature block when sending or replying to emails. In the government department, the macro works a treat and the email comes up with the signature block I included in the template, however in my firms email system I always have a signature block inserted at the top of my template generated email.

Can you help me out with this problem…how do I automatically (in the macro code or email settings) stop a signature block being generated when using the template. My preference is to not disable this function ‘permanently’ in the tools-options menu.

Reply | Quote

Can you help me out with this problem…how do I automatically (in the macro code or email settings) stop a signature block being generated when using the template. My preference is to not disable this function ‘permanently’ in the tools-options menu.

I’m interested in this, too. I did some digging around on the web and found this (http://www.outlookcode.com/d/ol2003problems.htm#sp1), but the solution doesn’t apply to emails generated from .OFT files. So, to raise the question again, if I have an email template that already includes a signature, how can I tell Outlook 2003 (SP2) not to generate a signature when creating an email from a template file?

thanks much,

Reply | Quote

I don’t personally have any information on this. I enter my signatures manually or by macro, or they already exist in the template I’m using. I never have used automatic signatures (from Outlook 97 forward).

Reply | Quote

Thanks for the sample code. I wanted to do the same thing as the original poster, and this subroutine was just what I needed.

Reply | Quote