Duplex 4-up postcard merge

[Jamie]

I have a 4-up postcard. I need to put variable data on BOTH sides of each
card. The data on side one must apply to the same person on side two. I have
never been able to get this to work. Additionally, when I have done a
simplex, 4-up merge, when I create the actual merge to document or printer,
it will merge 8 records into one file or print job. Why is this and how do I
fix it?

I have 45000 postcards to create, print, and mail to students before July 1.
These will be printed on a high-speed printer. I have done these for years,
but the back was always generic. so we would print it first then go back and
print the variable data.

I will take any help or suggestions at this point...I really need to have
variable data on both sides.

Thanks!

 

[Mary Sauer]

You are going to have to setup your database differently.

It means you will have to alternate the names

database one database two
Millie Smith John Doe
John Doe Millie Smith
Toots Smith Buster Brown
Buster Brown Toots Smith

There was a solution posted here some time ago. I will find it and supply the
URL.

 

[Mary Sauer]

Read this thread
http://groups.google.com/group/micr...c584402aca0/1aedea3f15eef287#1aedea3f15eef287
or
http://tinyurl.com/r6o53

 

[Jamie]

That would be fantastic, Mary. This has been driving me nuts for years with
these two annual mailings. This is the first year I can't get all of the data
on one side. I look forward to receiving the link you mentioned.

Thanks!!

 

[Mary Sauer]

Jamie, The link is in the message I sent earlier. Ignore my web page, it has
information for a different type of sort.

http://tinyurl.com/r6o53

This is Doug Robbins comment:

You must first merge one side of the cards with the data in its original 1, 2 ,
3, 4 order, then sort the Excel spread sheet on the column containing
(before you sort) 2, 1, 4, 3 so that after the sort, the numbers in that
columns are in the order 1, 2, 3, 4. Then with the data arranged in that
order, you execute the merge to the other side of the card.

http://tinyurl.com/r6o53

 

[Jamie]

ok...forget the printing on both sides for now. I am merging to a PDF, over
32,000 records. This is still the 4-up document. How do I get a mass quantity
of them to merge? Right now, they merge 8 records and want the file saved. I
am not going to be able to sit here and hit the return key 8,000 times to
save/send these files. I can send to a print queue, but then I don't have a
record of the files.

Help!!

 

[Mary Sauer]

Use Word. Word will merge to Acrobat without creating multiple PDF's.

 

[Ed Bennett]

Use Word. Word will merge to Acrobat without creating multiple PDF's.

So will Publisher if you use the Registry Fix (courtesy of KATMA).

Open registry using regedit.exe

Go to:
HKEY_CURRENT_USER\Software\Microsoft\Office\[Publisher
Version].0\Publisher\Printing

Create new "string value" called:
NumberOfRecordsPerBatch

Double click and set a value for your batch size.

(Although you'll need a beefy PC to handle an 8000-page print job and
PDF distillation)

 

[Jamie]

Ed,

I think I love you...and KATMA!! I am trying 2,000 records to start...that
is 500 pages. I think my system is beefy enough for that. Now, if I could
just figure out how that duplex variable data works. The formula and
everything suggested worked great. I just couldn't find information about how
to merge one page then the other (other than making two separate files) and
still have them collated for the two-sided printing. Sigh, that can wait. Now
that I am merging more than 8 records at a time...I am in heaven. Thanks
again!

Use Word. Word will merge to Acrobat without creating multiple PDF's.

So will Publisher if you use the Registry Fix (courtesy of KATMA).

Open registry using regedit.exe

Go to:
HKEY_CURRENT_USER\Software\Microsoft\Office\[Publisher
Version].0\Publisher\Printing

Create new "string value" called:
NumberOfRecordsPerBatch

Double click and set a value for your batch size.

(Although you'll need a beefy PC to handle an 8000-page print job and
PDF distillation)

 

[Mary Sauer]

I keep forgetting about this fix, I simply did not associate it with Acrobat. Is
this on your web site?
The KB has something similar.
--
Mary Sauer MSFT MVP
http://office.microsoft.com/

http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx

Use Word. Word will merge to Acrobat without creating multiple PDF's.

So will Publisher if you use the Registry Fix (courtesy of KATMA).

Open registry using regedit.exe

Go to:
HKEY_CURRENT_USER\Software\Microsoft\Office\[Publisher
Version].0\Publisher\Printing

Create new "string value" called:
NumberOfRecordsPerBatch

Double click and set a value for your batch size.

(Although you'll need a beefy PC to handle an 8000-page print job and PDF
distillation)

 

[Ed Bennett]

I keep forgetting about this fix, I simply did not associate it with Acrobat. Is
this on your web site?

It is now - I just added a tutorial.
http://ed.mvps.org/Static.aspx?=Publisher/registryfix

The KB has something similar.

That's because I pushed for it to be included - Microsoft weren't even
aware of the Registry Fix from what I could tell!