Mail Merge with Sub Records

[dickohead]

I have read a thread that is trying to do a very similar thing to me, but there was no final answer.

I have contact details for people, these people have subrecords in an assosciated table.

How do I generate a letter for each person and then include all assosciated sub records in their letter?

The sub records vary in both detail and quantity - some people might have 1, others can have 12.

 

[georgedwilkinson]

It's quite tricky and requires a lot of knowledge of the scripting language that Word uses to merge. I did it a long time ago on a 1:M report (a report showing criminal records of employees) but don't remember how I did it and where the code is located.

It doesn't really matter because my code was so incredibly convoluted and customized to the task that I couldn't imagine ever being able to re-use it. I imagine it would take me a couple of hours just to understand what it did, let alone explain it.

I found the method to accomplish it via google. I don't remember the search terms. but you can be assured that "merge" was in there somewhere. Probably something about detail, too.

 

[dickohead]

Cheers mate,

I figured it would be more complicated than "insert object x and it will read sub records".

Not to worry, I'll do it another way!

Thanks again mate.

 

[apr pillai]

Mail Merge Problem

Check this out. This may be the answer to your Problem.

http://www.msaccesstips.com/2007/10/ms-access-and-mail-merge-2.shtml

Regards,
a.p.r. pillai