Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-17-2011, 01:58 AM   #1
arronjuk
Newly Registered User
 
Join Date: Dec 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
arronjuk is on a distinguished road
Grouping for a mailmerge

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

arronjuk is offline   Reply With Quote
Old 11-30-2011, 12:47 AM   #2
Guus2005
AWF VIP
 
Guus2005's Avatar
 
Join Date: Jun 2007
Location: The Netherlands
Posts: 2,517
Thanks: 52
Thanked 84 Times in 77 Posts
Guus2005 has a spectacular aura about Guus2005 has a spectacular aura about Guus2005 has a spectacular aura about
Re: Grouping for a mailmerge

I hope your problem is solved since it was two weeks ago you entered this question.
If not i hope i can help.
Guus2005 is offline   Reply With Quote
Old 11-30-2011, 08:36 AM   #3
arronjuk
Newly Registered User
 
Join Date: Dec 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
arronjuk is on a distinguished road
Re: Grouping for a mailmerge

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! ! !

arronjuk is offline   Reply With Quote
Old 12-12-2011, 06:11 AM   #4
Guus2005
AWF VIP
 
Guus2005's Avatar
 
Join Date: Jun 2007
Location: The Netherlands
Posts: 2,517
Thanks: 52
Thanked 84 Times in 77 Posts
Guus2005 has a spectacular aura about Guus2005 has a spectacular aura about Guus2005 has a spectacular aura about
Re: Grouping for a mailmerge

Can you post a small sample of your database and word doc? Database and Word doc with bogus information if necessary.

Guus2005 is offline   Reply With Quote
Reply

Tags
mail merge , query , word

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge -- (again) GaryPanic General 0 01-04-2010 03:53 PM
Mailmerge Macjnr Modules & VBA 0 07-26-2009 03:03 AM
Grouping in a mailmerge to word. suepowell Reports 1 10-03-2004 11:04 PM
Mailmerge Pauldohert General 0 06-09-2004 02:28 AM
Mailmerge Gill General 3 07-05-2002 05:40 AM




All times are GMT -8. The time now is 06:00 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World