Mail Merge help 1

[lhughes]

I'm having a problem with the mail merge feature of Access. Here is some background. Table 1 named ParcelInfo consists of primary key, autonumber field named ParcelID and various other fields.

Table 2 named Retainage has its own primary key, autonumber field and a ParcelID lookup field reference to the ParcelID field in Table 1 and various other fields. These two tables are joined in a one to many relationship - the "one" being the ParcelInfo table and the "many" being the Retainage table.

There will be many retainage records to each ParcelInfo record. These tables, along with various others are part of a query created to merge with Word documents.

I have created a Word document but when I merge it with the query, instead of grouping all of the records from both tables for each individual ParcelID in into one document, it creates seperate Word documents for each record in the retainage table.

Can someone please tell me how to group the information for seperate documents created by ParcelID.

Below is a layout of the Word document.

Date

Address

ParcelID

Body of letter

List of Retainage Items for the Parcel
1.
2.
3.

Close of letter

Any help would be greatly appreciated!!!!!

 

[padinka]

In Word, open your Main Document,

Click on Tools
Click on Mail Merge
Click on the main document's CREATE button (Yes, CREATE)
Click on Catalog
Click on Change Document Type
Merge it with the data and it will be one document.
Don't forget to save your Main Document.




Trisha
padinka@yahoo.com