Sending Multiple Attachments To Multiple Users

  • Hi Guys,
    Please help with a following code. Something wrong , but I can't find an error. Code taking the name from "model" column in Excel, adding to it extention "doc" and looking it in SourcePath folder. After that it is adding to an email.
    I need to add to each message all attachents where the same name in "supplier" coulmn.


    From example file: email to Gold will sent with two attachments (polo.doc and bora.doc), while email to Toyota will sent one attachment only (yaris.doc).



    Please advise..


    Thanks

  • Re: Sending Multiple Attachments To Multiple Users


    Have you an error message, or is it a dysfunction ? What about the "GetFolderPath" instruction ? I can't get any VBA help about if.
    Daniel

  • Re: Sending Multiple Attachments To Multiple Users


    Dear Sir,


    GetFolderPath is a function that opens a dialog box, below its code:


    after number of trials, I changed the code to following:


    Now it works , but wrong.. :(. I thing that there is a problem with a logic. May you help?

  • Re: Sending Multiple Attachments To Multiple Users


    But, what's wrong ? The attachments are correct (only tested with XLS files though).
    Daniel

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!