Why can't I see ALL columns in Excel file during mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Halley - 29 Apr 2005 03:08 GMT

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?

Reply to this Message

Peter Jamieson - 29 Apr 2005 08:18 GMT

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

Peter Jamieson

>I am trying to do a mail merge, and everything is perfect, EXCEPT I have
>one
[quoted text clipped - 7 lines]
>
> Any suggestions?

Reply to this Message

Halley - 29 Apr 2005 13:08 GMT

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

> Let's assume your column has a name. Are there any hidden columns (with no
> column header or data) in your spreadsheet?
[quoted text clipped - 11 lines]
> >
> > Any suggestions?

Reply to this Message

Peter Jamieson - 29 Apr 2005 13:55 GMT

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

> No hidden columns - and this column is definitely not hidden.
>
[quoted text clipped - 14 lines]
>> >
>> > Any suggestions?

Reply to this Message

Rate this thread: