Thread: Outlook macro
View Single Post
 
Old 07-13-2017, 11:18 AM
teza2k06 teza2k06 is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default Outlook macro

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
Reply With Quote