Add Attachment To Email

  • I have created the following macro and am getting a debug error on the underlined line.



    The error says:
    "Run-time error '-2147024894 (80070002)':
    Cannot find this file. Verify the path and file name are correct."


    I have verified that the file does exist in the specified location. I appreciate any assistance.

  • Re: Add Attachment To Email


    I'm kind of out of my element with the Outlook object model but I do have two possibilities:


    1. An alternate spelling for Cancellation is to use one "l" (e.g. Cancelation). Is the file spelled the same way in your code as it is on your harddrive?
    2. I don't believe you need to enclose the file name in parentheses, only quotation marks. Parentheses usually indicate that the associated function is returning a value to a variable. In this case it is not.


    hth,


    Mav

  • Re: Add Attachment To Email



    Thanks for the ideas, Mav.
    1. I do have it spelled the same way.
    2. I tried this and received the same error.


    Seems like this should not be this difficult...any other ideas?


    Thanks!