Dear all
My excel sheet has list of invoices in Word format with their server addresses on Column D which is coming from SQL server. This is the location of the one invoice
"\\svr-storage3\Accounts_Data\Docs\H\H\A\HHA6\62\Bill ref 223615_458254_1.doc"
I have a macro that sends automatic email to my clients if their invoices unpaid over 35 days.
Is there a way that I can pull the invoice from the server with the above location address and converi it to PDF then attache to the email?
Here is my auto email code
Bookmarks