Help needed in Merge

[richardaristotle]

We have a merge instruction based on the current line in a record, which populates a word document. The tbl consists of:
OfferamountID
Status
AmountOffered
etc
At present the word merge populates the letter confirming the offer amount, however if a person offers on a property 6 times in a day I don't want to do six individual letters I want to do one letter but in the offer section fo the word document it would read. Any help would be greatly appreciated.

[TonyES]

Unless you are printing numerous letters at the end of a week, month or whatever, a Word merge is probably not the best way to do this. Automation is the better approach, as it lets you step through a record set and plug values into a table. You might find our Automation Tutorial useful for getting started with it - the article that Hans pointed you to also suggests that approach as one alternative. You might also consider using an Access report instead of a merge if you don't need any fancy formatting that requires Word.