First record printing twice?

[Brian Peasey]

Hi,

I have a minor problem with my mail merges. If I provide 3 records for
printing, it will output 4 forms. The extra form is a duplicate record #1
and is printed last.

I also noticed that after being prompted with the printer dialog box, there
is a smaller box that says something like "Now printing page 1...". This box
appears twice during the printing.

I'm connecting to Word 2000 via OLE with PowerBuilder 6.5., using embedded
VBA.

Any suggestions on the cause and cure for this problem?

Best Regards,
Brian

 

[Peter Jamieson]

Nothing obvious springs to mind but

a. what format is the data source?

b. what type of merge are you specifiying - Form Letter or Catalog?

is a smaller box that says something like "Now printing page 1...". This box
appears twice during the printing.

You are likely to get this if you are using a Form Letter type merge (in
fact I'd be surprised if you don't get it three or four times) becuase you
are probably always printing page 1 of each document, not pagaes 1-3 or 1-4
of a 3- or 4-page document.

 

[Cindy Meister -WordMVP-]

Hi Brian,

Sounds like this is a problem in the OLE code PowerBuilder is using. Certainly
there's nothing inherent in Word that would display this behavior.

I have a minor problem with my mail merges. If I provide 3 records for
printing, it will output 4 forms. The extra form is a duplicate record #1
and is printed last.

I also noticed that after being prompted with the printer dialog box, there
is a smaller box that says something like "Now printing page 1...". This box
appears twice during the printing.

I'm connecting to Word 2000 via OLE with PowerBuilder 6.5., using embedded
VBA.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Brian Peasey]

Thank you Peter and Cindy,

I have more information..

I created a new template, with only one merge field. It works correctly.
There is no extra printout and there are no print dialog boxes etc. when it
runs.
This makes me think something happened to the template our client is using,
as it originally worked correctly in the beginning.

I really don't want to create a new one from scratch if at all possible. I
will compare all the options/properties between the original and the new
template.
If you have any ideas or suggestions, please post them.

Best Regards,
Brian

 

[Brian Peasey]

Hi,

I found the cause. In the old template is was set to merge "to printer".
Changing it to merge to "new document" fixed it for me. Thanks again

Best Regards,
Brian