Mail Merge - Many Records for Each Addressee
Hi,
This is having me tearing my hair out!
I want to send a letter to a number of suppliers, each of which has a number of different contracts with our company i.e.
Supplier X will have Contract 1 and Contract 2
Supplier Y will have Contract 3 and Contract4
I don't want to send lots of different letters to the same supplier, just one detailing all the the contracts they have.
At the moment the data is in Excel.
I think the answer may be in using Access (One to Many Relationship?) or using Field codes in Word. I can set up tables and queries in Access, so would prefer that way.
Any ideas.
Thanks,
Andrew
|