Word Merge (v2002)

Topic

New Reply

I searched high and low and none of the posts quite addressed my issue. I currently have code that merges a Word Document with a single-record query that works quite well. I need to modify my code to run the merge on a query with multiple records. The caveat is I don’t want to have one resultant merge file. I want each record to appear in a separate document. Do I need to loop and close the merge template each time or is there something in Word that can help me (I did search the Word forum and couldn’t find any answers).
Thanks a bunch!!!

Reply | Quote

Replies

One option is to loop through the records and do a single-record merge for each record.
Another option is to merge all records into a single Word document, then use Word VBA to split the merged document. See this newsgroup thread.

Reply | Quote

Thanks Hans…I think the loop route is the way I’ll go…I just wanted to make sure I wasn’t missing another approach.

Also, FYI – that Red, Yellow, Green status code you helped me with is working wonderfully. We’ve been swamped with the rollout and it’s all coming together and I credit you for helping bridge a gap too wide for my skills.
Have a great night!!
Andrew

Reply | Quote