open a word application
for each label
open the template
fill in the product identification information
print the document
close the document without saving
next label
Close word
The problem is the program worked fine with small test of about 3 labels, when creating 100 labels which equates to 100 print jobs, they do not print in sequence. In one test case it started with the documents 12 - 27, then printed 1 - 11, then started back at 28. Is there anyway to control the print jobs to make them print in sequence?
If not any suggestions or examples of VB copying one word doc to another or doing a mail merge.
TIA