Outlook macro

teza2k06 · #1 07-13-2017, 11:18 AM

Hi All,
I have found some basic macro coding online so that when i click a button on my ribbon it will open up the e-mail template

Code:

Sub email()
Set msg = Application.CreateItemFromTemplate("C:\Users\trb19\Desktop\test email.oft")
msg.Display
End Sub

The above code works with no problems.

However i have used the same coding (below) so that it opens a similar email, but with an attachment that will be sent in the e-mail. I have added this macro to the ribbon, but when i click on this button nothing happens

Code:

Sub InterviewPaperwork()
Set msg = Application.CreateItemFromTemplate("C:\Users\trb19\Desktop\interview record.oft")
msg.Display
End Sub

I am new to this, so it might just be a little error that i have done, but could anyone help me out so that it will open the email template with attachment??

Many thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Macro code for Outlook	gbaker	Outlook	0	04-11-2013 10:29 AM
CSV data to Outlook macro	gbaker	Excel Programming	3	03-28-2013 09:17 PM
Need help on Outlook 2010 Macro	rainpuppy	Outlook	4	02-04-2013 12:44 AM
Macro help outlook 2010	seanchad	Outlook	0	06-28-2012 02:49 AM
Enable/Disable Macro in Outlook	JimDandy	Misc	0	05-11-2006 06:17 AM