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

H

Halley

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?
 
P

Peter Jamieson

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

Peter Jamieson
 
P

Peter Jamieson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Mail Merge - displaying a conditional number of decimals 5
Autonumber field in Excel that behaves the same as Access 0
Conditional Mail Merge won't suppress blank lines 2
Mail Merge: cannot display the field in Excel correctly 1
Email Mail Merge via linked Excel sheet 0
Mail Merge Help 0
Word 20102 - Insert 1 of 38 AutoText Entries During Mail Merge 0

Top