How to get a new page for each person

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dixie - 25 Aug 2005 23:49 GMT

I am trying to produce certificates which list the achievements of each
person on a separate document (sheet). The number of achievements for each
person will not be the same. Each achievement will be in a single record in
a table in Access 2000. The same field must be used for each achievement.
I am fairly sure I will have to use a catalogue type merge document.. How
am I going to get a new certificate for each person I don't want to print
them one at a time as there are hundreds of certificates involved. It would
be nice to just click the print button on an Access form when all the data
is entered and have a single certificate for the achievements of each person
come out of the printer. My problem is having a new certificate document
start for each different person.

I am familiar with ordinary mailmerge where you are sending one record to a
document, but have never attempted anything like this. Any help would be
appreciated.

TIA
dixie

Reply to this Message

Doug Robbins - 26 Aug 2005 05:42 GMT

Using a formletter type mail merge will produce a new sheet for each
certificate.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to produce certificates which list the achievements of each
>person on a separate document (sheet). The number of achievements for each
[quoted text clipped - 14 lines]
> TIA
> dixie

Reply to this Message

Graham Mayor - 26 Aug 2005 06:17 GMT

The procedure is exactly the same - create your certificate as a one page
form letter merge document.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am trying to produce certificates which list the achievements of
> each person on a separate document (sheet). The number of
[quoted text clipped - 14 lines]
> TIA
> dixie

Reply to this Message

Dixie - 26 Aug 2005 07:36 GMT

I've tried this. The problem is that it is taking a page for each record in
MSAccess. I want a single page certificate for each person, but each person
may have anything up to say 10 awards which must be printed on the same
certificate. This means that in the query in Access, there could be 10
records for that person (or certificate). Each person does not have the
same number of awards.

So what I want basically is some information at the top of the certificate
that is to be printed only once and then I need the individual awared
records on that one page.

For example a single certificate needs to be in this form:

Yosemite Central Study Centre
Graduate: Jack Smith

Hammer users certificate
1st in advanced poetry
2nd in Partying
Meritorious performance in screwing up.

Signed: Joe Bloggs
Company Ratbag.

I've tried calalog and form letter, but in form letter, I get a new page per
entry, while in calog, it doesn't take a new page for a new person.

Any ideas?

dixie

> The procedure is exactly the same - create your certificate as a one page
> form letter merge document.
[quoted text clipped - 17 lines]
>> TIA
>> dixie

Reply to this Message

Graham Mayor - 26 Aug 2005 11:16 GMT

That's much more tricky to do - see the complex merges documentation on
Cindy's web site
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I've tried this. The problem is that it is taking a page for each
> record in MSAccess. I want a single page certificate for each
[quoted text clipped - 56 lines]
>>> TIA
>>> dixie

Reply to this Message

Dixie - 26 Aug 2005 12:12 GMT

Blast, I really didn't want to go with internal reports in Access as it
prevents customers from being able to modify the certificates to suit their
own likes/dislikes and means that I have to do them for each customer
independently. Oh well, you can alway live in hope. I wonder why this type
of mailmerge is not available through Word, it would not exactly be a unique
document.

Thanks anyway
dixie

> That's much more tricky to do - see the complex merges documentation on
> Cindy's web site
[quoted text clipped - 60 lines]
>>>> TIA
>>>> dixie

Reply to this Message

JohnB - 26 Aug 2005 17:39 GMT

Dixie.

What you need is something that allows you to "concatenate" fields. I got a
module designed by, I think, Duanne Hookum over on the Access Discussion
Group some months ago. This concatenates a given field in the "many" side
records relevent to each related "one" side. The results appear as an
expression field in a query.

This allows me to create a mail merge consisting of individual pages for
each School (the "one" side) and on each page is shown fields from the "many"
side records - student names. The names appear in a column because I
separated them using carriage return and line feed characters in the code
calling up the concatenate module.

It seems that this is exactly what you need, although I believe that there
are other ways to concatenate fields in Access. Unfortunately I will not be
able to help you further until next Tuesday at the earliest but in the
meantime, I suggest you post a question about concatenating on the Access
Discussion Group. You may be able to get help on Concatenating more quickly
there.

Best of luck, JohnB

> Blast, I really didn't want to go with internal reports in Access as it
> prevents customers from being able to modify the certificates to suit their
[quoted text clipped - 70 lines]
> >>>> TIA
> >>>> dixie

Reply to this Message

Dixie - 28 Aug 2005 05:33 GMT

Have got it working with that idea - thanks to all who answered. It is not
really a mailmerge problem, but more an Access task.

dixie

> Dixie.
>
[quoted text clipped - 100 lines]
>> >>>> TIA
>> >>>> dixie

Reply to this Message

Rate this thread: