Hello,
I am trying to make a process more efficient where by each name in my spreadsheet has a pdf attachment that needs to be sent out to them. Instead of manually attaching each file in the email the VBA opens I would like the VBA to refer to the cell with the hyperlink to the PDF and then attach it. Does anyone know how I can do this/have any code that may help? Please bear in mind that I am quite new to macros.
Thank you in advance.
I am trying to make a process more efficient where by each name in my spreadsheet has a pdf attachment that needs to be sent out to them. Instead of manually attaching each file in the email the VBA opens I would like the VBA to refer to the cell with the hyperlink to the PDF and then attach it. Does anyone know how I can do this/have any code that may help? Please bear in mind that I am quite new to macros.
Thank you in advance.
