Missing fields (columns)

[Pete the Pilot]

Using Word 2007 Office Std
I'm in the insert merge field window with database field radio button
on. I want to merge data from an excel file that has 10 columns
(fields). Problem is I see only 8 of the 10 columns (fields). In the
matchfield window I also see only 8 of the 10 columns (fields).
How do I get my Word 2007 mail merge to see all there is to see in the
excel file, namely the 10 columns? It sees all the lines, why not all
the columns?
Thanx in advance.
Pete

 

[Peter Jamieson]

Are there any hidden columns in your Excel sheet?

If not, what are the column names in the 8th,9th, 10th columns?

 

[Pete the Pilot]

Peter,
No hidden columns, however your question caused me to muck
around a bit. I must have set up some printing parameters some time
in the past that I'd forgotten all about. By moving the page breaks
to include all of the worksheet in question, mail merge now sees all
columns A thru J. A bit embarrased but a bit wiser. Thanx and enjoy
the holidays.
Pete

 

[Peter Jamieson]

and enjoy

the holidays.

You too. But if you do pop back in, when you selected the data source, did
you select a "table" called _xlnm#Print_Area?

If so, that's a "named range" which specifies whatever area you have defined
as your Print Area. If you want the whole sheet (or rather, a "table" at the
top left of it) choose the entry in that list of tables with the name of the
sheet - e.g. Sheet1$.

 

[Lauren]

I'm having this same challenge, except that my print area is set correctly.
What else perhaps could be the cause?

 

[Peter Jamieson]

Can you confirm that selecting the sheet name in the list of data sources in
the Workbook does not work either?