Grouping for a mailmerge (1 Viewer)

arronjuk

New member
Local time
Today, 22:31
Joined
Dec 9, 2007
Messages
5
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! :confused:

Many thanks,

Arron
 

Guus2005

AWF VIP
Local time
Today, 23:31
Joined
Jun 26, 2007
Messages
2,645
I hope your problem is solved since it was two weeks ago you entered this question.
If not i hope i can help.
 

arronjuk

New member
Local time
Today, 22:31
Joined
Dec 9, 2007
Messages
5
No it's not fixed, at the moment, I have had to put a temp workaround using a report instead of a mailmerge.

But any help you can give on making this work with Word will be very appreciated! ! !
 

Guus2005

AWF VIP
Local time
Today, 23:31
Joined
Jun 26, 2007
Messages
2,645
Can you post a small sample of your database and word doc? Database and Word doc with bogus information if necessary.
 

Users who are viewing this thread

Top Bottom