Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
The procedure is essentially that at -
http://support.microsoft.com/?kbid=294686 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org magicdds wrote: 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. |
#3
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 "Graham Mayor" wrote: The procedure is essentially that at - http://support.microsoft.com/?kbid=294686 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org magicdds wrote: 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. |
#4
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
See
http://cornell.veplan.net/article.aspx?&a=3815 If I were you however, I would use an Access Report instead. -- 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 "magicdds" wrote in message ... 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. |
#5
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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. "Doug Robbins - Word MVP" wrote: See http://cornell.veplan.net/article.aspx?&a=3815 If I were you however, I would use an Access Report instead. -- 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 "magicdds" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Test Alignment issue in Table with Merge Cells (rows) | Tables | |||
mail merge not going to next record | Mailmerge | |||
HOW DO I USE MERGE RECORD#TO NUMBER EACH PAGE PRINTED | Microsoft Word Help | |||
sort mail merge by merge record number | Mailmerge | |||
label merge only 1st record is merging-rest of source won't merge | Mailmerge |