View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mailmerge - cloning field results

What about the other 40 records?

Set up your formletter type merge document as just one page with 20 sets of
mergefields on it with a Next Record field before the first mergefield
in all but the first set of records on the page. Then execute your merge to
a new document and in the file print dialog, specify the pages to be printed
as

s1,s1,s2,s2,s3,s3

with your printer set to print in duplex mode.

--
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, originally posted via msnews.microsoft.com
"Marski99_99" wrote in message
...
Example:

1. Excel table with 120 rows
2. Word template for creating mailing has:
- 1st page - table with first 20 rows (should be merged from Excel)
- 2nd page (back of 1st page) - should have cloned (copied) table from 1st
page
- 3rd page- table with next 20 rows (should be merged from Excel)
- 4th page (back of 2nd page) - should have cloned (copied) table from 3rd
page

How can achieve that? Please help me.
--
Word investigator