Missing fields (columns)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete the Pilot - 23 Dec 2007 05:30 GMT

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

Reply to this Message

Peter Jamieson - 23 Dec 2007 18:23 GMT

Are there any hidden columns in your Excel sheet?

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

Signature

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

> Using Word 2007 Office Std
> I'm in the insert merge field window with database field radio button
[quoted text clipped - 6 lines]
> Thanx in advance.
> Pete

Reply to this Message

Pete the Pilot - 24 Dec 2007 02:01 GMT

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

Reply to this Message

Peter Jamieson - 24 Dec 2007 09:16 GMT

> 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$.

Signature

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

> Peter,
> No hidden columns, however your question caused me to muck
[quoted text clipped - 4 lines]
> the holidays.
> Pete

Reply to this Message

Lauren - 08 Jan 2008 16:41 GMT

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

> > and enjoy
> > the holidays.
[quoted text clipped - 15 lines]
> > the holidays.
> > Pete

Reply to this Message

Peter Jamieson - 09 Jan 2008 23:39 GMT

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

Signature

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

> I'm having this same challenge, except that my print area is set
> correctly.
[quoted text clipped - 23 lines]
>> > the holidays.
>> > Pete

Reply to this Message