[John]

Peter - I did do this in the mean time and guess what - it worked. I have
some more iterations to do through this week and want to verify that it
continues to work. If so, I will post status here. For the record: I saved
the Excel file as the XLS and kept the Word file as DocX.


--
QWERTY


"Peter Jamieson" wrote:

I wish I could be precise about this, but there do seem to be more
problems with Word 2007 mailmerge when using the .docx/.xlsx formats.
I've had situations, for example, where I haven't been able to access
more than around 42 columns using DDE, but then in other situations it
works fine.

I wonder if, as an experiment, you could try saving your workbook as a
..xls and your document as a .doc and see if you encounter the same
problem (my suspicion is that if that's OK, it's more to do with the
..doc than the .xls)


Peter Jamieson
http://tips.pjmsn.me.uk

John wrote:
Sorry if this is posted in here twice - received a 'temporarily unavailable
error' on my last attempt.

Peter €“ thanks for your help
I am using Office 2007 (xlsx and docx) The Excel file was originally
created in 2003 then recently converted to 2007. The Word doc may have been
created in 2003 or 2007. I dont remember as the rollout of 2007 is
concurrent with my building this tool.
I have no hidden rows or columns, nor am I moving, adding or deleting any.
€˜Q3 Den was the 15th of 34 columns.
Now, for fun, I removed all spaces from column headers €˜Q3 Den is now
€˜Q3Den. This resulted in a successful merge once. Now the same issue is
occurring but starting at a later column €˜Intro2 (26 of 34).