View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Many extra pages appearing from Excel mail merge

I don't have those files (or that machine) any more, I'm afraid,

Wow! That one went through the window fast! :-)

but I'm still kind of curious to know what happened.


I remember that feeling well! However, there are so many ways in which
things can go wrong that these days I try to confine my curiosity to the
cases where there is some chance of finding out what caused the problem,
which generally requires that someone is in a position to experiment, and
even in those circumstances it's frequently easier to start from scratch and
see if the problem goes away with a new set of files etc.

Peter Jamieson


"Tara H" wrote in message
...
Hi Peter - it was Word and Excel XP. I don't know which connection method
it
was using, I just clicked on the data source button on the mail merge
toolbar. I don't have those files (or that machine) any more, I'm afraid,
but I'm still kind of curious to know what happened.

Thanks,
Tara


"Peter Jamieson" wrote:

I don't know what is happeneing, but which version of Word and Excel, and
which method are you using to connect? (You can change methods in Word
2000
and earlier by checking "Select method" in the Open Data Source dialog
box
and choosing DDE, ODBC, or the converter. You can change methods in Word
2002 and later by checking Word Tools|Options|General|Confirm conversions
at
open and re-connecting to the data source, and selecting the method you
want).Typically, you will only be able to connect to the sheet you most
recently had open when you use DDE.

Peter Jamieson