| View previous topic :: View next topic |
| Author |
Message |
Pete the Pilot
Guest
|
 Posted: Sun Dec 23, 2007 5:30 am Post subject: Missing fields (columns) |
 |
|
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 |
|
| Back to top |
|
 |
Google
Sponsor
|
| Posted: Sun Dec 23, 2007 5:30 am Post subject: Advertisement |
|
|
|
|
| Back to top |
|
|
Peter Jamieson
Guest
|
| Posted: Sun Dec 23, 2007 6:23 pm Post subject: Re: Missing fields (columns) |
|
|
Are there any hidden columns in your Excel sheet?
If not, what are the column names in the 8th,9th, 10th columns?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Pete the Pilot" <nodakit@att.biz> wrote in message
news:pvrrm3tceh6cnt3t54ba1sqsuas1njv0ql@4ax.com...
| Quote: | 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 |
|
|
| Back to top |
|
|
Pete the Pilot
Guest
|
| Posted: Mon Dec 24, 2007 2:01 am Post subject: Re: Missing fields (columns) |
|
|
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 |
|
| Back to top |
|
|
|
