Outlook macro

Discussion in 'Outlook' started by teza2k06, Jul 13, 2017.

  1. teza2k06

    teza2k06

    Joined:
    Aug 23, 2014
    Messages:
    2
    Likes Received:
    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
     
    teza2k06, Jul 13, 2017
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.