Thread: sending personalized email with attachment to several recipients
View Single Post
 
Old 09-29-2021, 08:51 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,101
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
Your merge document is empty. It needs at least 1 merge field e.g. Name and the text content of the message body.
Your worksheet does not contain the paths for the attachments
Instead of PRINTEX1, your data field should contain C:\Path\PRINTEX1.pdf, where C:\Path\ is the folder in which the file is located, and should include the extension .pdf or the attachment will not be found. With these corrected, the merge will complete to the Outlook outbox.
__________________
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