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
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
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
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