Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word Merge (v2002)

    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!!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Word Merge (v2002)

    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.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Merge (v2002)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •