Column Y has invoice hyperlink , transfer the link to PDF and attach to an email.

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • I have a excel sheet which has Hyperlink on Column Y to open invoices in word document. I like to run a macro and open the invoice from the link convert to PDF and attach to an email.


    Below code is for the invoice named MyReport.docx on desktop , so I like to change this code so that invoices comes from Column Y on Excel sheet.


    Is it possible?


  • Re: Column Y has invoice hyperlink , transfer the link to PDF and attache to an ema


    I have also this code to attach the invoices as word document in to an email but I like the invoices attached as PDF.


  • Re: Column Y has invoice hyperlink , transfer the link to PDF and attache to an ema


    Can anyone help please?



    Quote from Lapot;730175

    I have also this code to attach the invoices as word document in to an email but I like the invoices attached as PDF.


Participate now!

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