View Single Post
 
Old 08-20-2021, 09:10 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

To use mail merge you would create an Excel worksheet that lists the recipient details, the Invoice Numbers, the PO Numbers, Company Names and Full Paths of the PDF files, all on one row for each invoice number.



The chances of extracting the data from the PDF files to the worksheet (or to the email as your original suggestion) are slim, and impossible without access to a sample.

Configure your email body as a Word document and insert the fields as required. Then, using the add-in, merge the data with the document to the body of an email and select the fields for the attachment.
The use of the process is documented on my web site and there is plenty of context sensitive help.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote