Outlook macro


Joined
Aug 23, 2014
Messages
2
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top