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

Example.zip (19.9 KB, 15 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

I am still having some trouble. I have had 2 outcomes:

1. When I first connect the data source and run the macro I have to run it 3-4 times and it either exports 1,2 or 3 files (screen recording attached)

2. When I delete those saved files from the folder (Created above) and I run the macro, I can see the preview of the file exporting all of the different data and saving the file on top of itself (screen recording attached), so I only end up with one file.

Any thoughts on why this might be?

Attached Files

	1. multiple macro runs needed.gif.zip (1.89 MB, 11 views)
	2. file saving over itself.gif.zip (860.2 KB, 10 views)