I am trying to do a mail merge, and everything is perfect, EXCEPT I have one
column of data in my Excel field that is not showing up as an option in the
Mail Merge fields in Word. I need to get this additional column. I even tried
deleting some columns (in case there was a max number of mail merge fields),
and that didn't work.

Any suggestions?

Let's assume your column has a name. Are there any hidden columns (with no
column header or data) in your spreadsheet?

Peter Jamieson
"Halley" wrote in message
...
I am trying to do a mail merge, and everything is perfect, EXCEPT I have
one
column of data in my Excel field that is not showing up as an option in
the
Mail Merge fields in Word. I need to get this additional column. I even
tried
deleting some columns (in case there was a max number of mail merge
fields),
and that didn't work.

Any suggestions?

No hidden columns - and this column is definitely not hidden.

"Peter Jamieson" wrote:

Let's assume your column has a name. Are there any hidden columns (with no
column header or data) in your spreadsheet?

Peter Jamieson
"Halley" wrote in message
...
I am trying to do a mail merge, and everything is perfect, EXCEPT I have
one
column of data in my Excel field that is not showing up as an option in
the
Mail Merge fields in Word. I need to get this additional column. I even
tried
deleting some columns (in case there was a max number of mail merge
fields),
and that didn't work.

Any suggestions?

Just suggestions:
a. if you haven't actually tried reconnecting, try that
b. personally I would want to see what happened if I cut/paste the
offending column into a new sheet, probably with one more column to ensure
Word connects.
c. Check Word Tools|Options|Gneral|"Confirm conversion at open" (Word
2002/2003) and try the other available connection methods - probably DDE and
ODBC in your case.

Peter Jamieson

"Halley" wrote in message
news
No hidden columns - and this column is definitely not hidden.

"Peter Jamieson" wrote:

Let's assume your column has a name. Are there any hidden columns (with
no
column header or data) in your spreadsheet?

Peter Jamieson
"Halley" wrote in message
...
I am trying to do a mail merge, and everything is perfect, EXCEPT I have
one
column of data in my Excel field that is not showing up as an option in
the
Mail Merge fields in Word. I need to get this additional column. I even
tried
deleting some columns (in case there was a max number of mail merge
fields),
and that didn't work.

Any suggestions?