Combining Records in Access to Word Mail Merge

[drbtodd1971]

Hi,
I'm trying to create a Word mail merge based on Access Data which will produce letters. The letters need to display the personal details and then any houses the person has which can range from 1 to any number.

The data is sorted on PersonID from three tables.

tblPerson - Main Key is PersonID
tblPersonLandInterests - Based on PersonID and Plot_Number
tblLandDetails - Main Key Plot_Number

I'm guessing using VBA is the only way forward as you can't be certain how many houses a person will have. The problem is we have to use Word 2000, I have found solutions to the problem for 2003 but even trying them seems to give no joy.
Has anyone any ideas how to resolve this problem, I've found several knowledge base entries but they don't seem that useful.

Structure of letter would look like this:

Forename
Surname
Job title
Business
Address1
Address2
Address3
PostCode

RE: Property 1
RE: Property 2 etc up to any number

 

[psemianonymous]

The short answer is that this is not something Mailmerge is designed for.

My first recommendation is that you build a report in Access to build your "letter"--reports have very good support for subgroupings and subreports. The downside is of course, you can't use Word for this.

If you absolutely must do Word Mailmerge, it will be more difficult. I'm not a mailmerge expert, but from what I've seen, it won't be possible to do subgroupings within it.

So build a report, is my advice.

 

[drbtodd1971]

Got it to work by concatenating the property fields into one field per person and attaching carriage returns between properties. Then when word picks it up it treats it as one field but each property appears on a seperate line so it looks like multiple entries.