Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Paul P. Paul P. is offline
external usenet poster
 
Posts: 5
Default Same record repeats on mailing labels

I am using mailmerge to print out a few thousand records to Avery form 5388
(Index Cards). I have created a template with Field names in each area of the
form with the associated MergeField. I have copied the form (as nested table)
into the first record on the 5388 form and I have also tried copying the form
into each of the labels on the 5388 form. The result is the same. Each record
repeats on the page. This triples the desired output.
What I am trying to do is to print one record in each label. I have created
a rec_number field and used query options to filter. This outputs 3 labels
per page with incremental record numbers for each record. So the rec_number
field is working but I still cannot get 3 individual records per page.
--
Paul P.
IHS
Neah Bay, WA
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Same record repeats on mailing labels

You need to have a { NEXT } field at the beginning of each copy of your form
/except the first/, to get Word to move to the next record.. You can use
Alt-F9 to show the "raw" field codes, then use ctrl-F9 to insert the special
field code braces, then type NEXT between them.

e.g. if you have 3 copies of the form in your mail merge main document

form-A
form-B
form-C

then you need { NEXT } fields as follows:

form-A
{ NEXT }
form-B
{ NEXT }
form-C

(I'm not sure that will actually work with nested tables, but if you have
problems at first, try to put the { NEXT } fields in the outer-level table).

Peter Jamieson

"Paul P." wrote in message
...
I am using mailmerge to print out a few thousand records to Avery form 5388
(Index Cards). I have created a template with Field names in each area of
the
form with the associated MergeField. I have copied the form (as nested
table)
into the first record on the 5388 form and I have also tried copying the
form
into each of the labels on the 5388 form. The result is the same. Each
record
repeats on the page. This triples the desired output.
What I am trying to do is to print one record in each label. I have
created
a rec_number field and used query options to filter. This outputs 3 labels
per page with incremental record numbers for each record. So the
rec_number
field is working but I still cannot get 3 individual records per page.
--
Paul P.
IHS
Neah Bay, WA



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Paul P. Paul P. is offline
external usenet poster
 
Posts: 5
Default Same record repeats on mailing labels

Thank you very much for the help.

Here is what I ended up doing.
1. I created a new document with a table the full size of the page. I split
it horizontally and vertically into 4 cells. I pasted my original template as
a nested table into each cell. I added a {Next} field into each nested table.
2. I inserted a column in the data source spreadsheet named Rec_Number and
created a sequential number for each record.
3. When I started the merge I set the query options to: Field=Rec_Num;
Comparison=Less than or equal to;Compare to=2271(the number of records).
4. I set the merge to create new document because I am printing to 110 lb
card stock and I want to be able to restart the print job at my direction in
case I encounter a paper jam.

What helped the most in your reply was:
You need to have a { NEXT } field at the beginning of each copy of your form
/except the first/, to get Word to move to the next record.. You can use
Alt-F9 to show the "raw" field codes, then use ctrl-F9 to insert the special
field code braces, then type NEXT between them


Thanks again.

Paul Pacelli
--
Paul P.
IHS
Neah Bay, WA


"Peter Jamieson" wrote:

You need to have a { NEXT } field at the beginning of each copy of your form
/except the first/, to get Word to move to the next record.. You can use
Alt-F9 to show the "raw" field codes, then use ctrl-F9 to insert the special
field code braces, then type NEXT between them.

e.g. if you have 3 copies of the form in your mail merge main document

form-A
form-B
form-C

then you need { NEXT } fields as follows:

form-A
{ NEXT }
form-B
{ NEXT }
form-C

(I'm not sure that will actually work with nested tables, but if you have
problems at first, try to put the { NEXT } fields in the outer-level table).

Peter Jamieson

"Paul P." wrote in message
...
I am using mailmerge to print out a few thousand records to Avery form 5388
(Index Cards). I have created a template with Field names in each area of
the
form with the associated MergeField. I have copied the form (as nested
table)
into the first record on the 5388 form and I have also tried copying the
form
into each of the labels on the 5388 form. The result is the same. Each
record
repeats on the page. This triples the desired output.
What I am trying to do is to print one record in each label. I have
created
a rec_number field and used query options to filter. This outputs 3 labels
per page with incremental record numbers for each record. So the
rec_number
field is working but I still cannot get 3 individual records per page.
--
Paul P.
IHS
Neah Bay, WA




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging labels from excel starts second page with second record Debbie Mailmerge 1 February 8th 06 07:17 PM
Next Record If, problems with merging multiple records [email protected] Mailmerge 0 January 13th 06 04:38 PM
Add picture to mailing labels SRS Mailmerge 1 November 2nd 05 05:36 AM
Creating mailing labels with the Mail Merge Helper Stephen White New Users 1 April 5th 05 02:25 PM
Mailing Labels - Outlook to Word? Charliec Mailmerge 2 December 5th 04 05:46 PM


All times are GMT +1. The time now is 06:42 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"