Thread: [Solved] Automate mail merge to save each record individually using VBA
View Single Post
 
Old 12-06-2021, 01:34 AM
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
If the data sheet was viable (It has an incompatible ROW1 and several empty rows after the sixth record) and you remove the unassociated field from the document then save it as a DOCX format (see attached) the code I posted works without problem. See attached. You'll need to reattach the data file.
Run the code from your normal template.
Attached Files
File Type: zip Example.zip (19.9 KB, 9 views)
__________________
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