Hi All, I'm trying to build an export for product renewals.
It will be done monthly, so I have a query that gets the company info from one table, and the products due for renewal from another. The records are joined via customerID.
The query is then merged with a Word template. It all works well, except for where a company has multiple products due for renewal it create multiple renewal forms in Word, I want one Word renewal form per customer, with multiple products.
I can achieve this if I use a report and groups, but the customer needs it to merge to word.
For the life of my I can't figure out a way.
Really hoping someone out there has an idea, as am running out of time to deadline!
Many thanks,
Arron
It will be done monthly, so I have a query that gets the company info from one table, and the products due for renewal from another. The records are joined via customerID.
The query is then merged with a Word template. It all works well, except for where a company has multiple products due for renewal it create multiple renewal forms in Word, I want one Word renewal form per customer, with multiple products.
I can achieve this if I use a report and groups, but the customer needs it to merge to word.
For the life of my I can't figure out a way.
Really hoping someone out there has an idea, as am running out of time to deadline!
Many thanks,
Arron