![]() |
|
#4
|
||||
|
||||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Form auto fill based on a different field value.
|
stct | Word | 31 | 05-02-2024 04:48 PM |
Table to auto create columns to fill page
|
deweyirl | Word Tables | 1 | 05-12-2021 02:27 PM |
| Auto fill based on previous entry | geojf3 | Word VBA | 6 | 11-25-2019 06:49 AM |
| Auto fill drops down using VBA code based on selection | AgilityJS | Word VBA | 5 | 11-03-2015 07:50 PM |
run word doc when a email is received with a certain subject based on rules
|
megatronixs | Outlook | 3 | 10-18-2014 11:47 AM |