How can I test for the last record printed in a merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magicdds - 21 Mar 2008 05:28 GMT

I am using a catalog to print multiple records from Access into a single
letter in Word. To have and opening paragraph, I check if MERGESEQ = 1 and if
it is, Word adds the opening paragraph. After the last record of data is
printed in the body of the letter, I would like the concluding paragraph to
be printed. How can I have word check if the last record was printed? The
number of records printed in the letter is always different, so I can't check
if MERGESEQ or MERGEREC = a specific number.

Reply to this Message

Graham Mayor - 21 Mar 2008 09:21 GMT

The procedure is essentially that at -
http://support.microsoft.com/?kbid=294686

Signature

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

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

> I am using a catalog to print multiple records from Access into a
> single letter in Word. To have and opening paragraph, I check if
[quoted text clipped - 4 lines]
> in the letter is always different, so I can't check if MERGESEQ or
> MERGEREC = a specific number.

Reply to this Message

magicdds - 21 Mar 2008 18:43 GMT

This article addresses what I already have in my letter. I already am testing
MERGESEQ for the first record. The article does not address how to test for
the last record so that I can print the concluding paragraph after all the
records have been printed. Is there a way to test for the last record?

Thanks
Mark

> The procedure is essentially that at -
> http://support.microsoft.com/?kbid=294686
[quoted text clipped - 7 lines]
> > in the letter is always different, so I can't check if MERGESEQ or
> > MERGEREC = a specific number.

Reply to this Message

Doug Robbins - Word MVP - 22 Mar 2008 12:20 GMT

See
http://cornell.veplan.net/article.aspx?&a=3815

If I were you however, I would use an Access Report instead.

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 using a catalog to print multiple records from Access into a single
> letter in Word. To have and opening paragraph, I check if MERGESEQ = 1 and
[quoted text clipped - 6 lines]
> check
> if MERGESEQ or MERGEREC = a specific number.

Reply to this Message

magicdds- - 23 Mar 2008 17:59 GMT

That web site had the answer (that I was not hoping for) in the last
sentence. Word cannot test for the last merged record!

Thanks for trying though.

> See
> http://cornell.veplan.net/article.aspx?&a=3815
[quoted text clipped - 11 lines]
> > check
> > if MERGESEQ or MERGEREC = a specific number.

Reply to this Message

Rate this thread: