Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 08-20-2021, 09:10 PM
gmayor's Avatar
gmayor gmayor is offline Auto Create or Fill Email Based on the Subject Windows 10 Auto Create or Fill Email Based on the Subject Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,144
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 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Create or Fill Email Based on the Subject Form auto fill based on a different field value. stct Word 31 05-02-2024 04:48 PM
Auto Create or Fill Email Based on the Subject 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
Auto Create or Fill Email Based on the Subject run word doc when a email is received with a certain subject based on rules megatronixs Outlook 3 10-18-2014 11:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft