How do I add 165 Merge Fields form Excel to a Word doc?

[Stefanus Snyman]

I want to mai merge in Word 2003 from an Excel document (165 columns), but
when I want to insert merge fields in Word I can only see about 50 columns to
insert. Is there a limit to the number of merge fields Word can handle.
Please help!!

 

[Cindy M.]

Hi =?Utf-8?B?U3RlZmFudXMgU255bWFu?=,

I want to mai merge in Word 2003 from an Excel document (165 columns), but
when I want to insert merge fields in Word I can only see about 50 columns to
insert. Is there a limit to the number of merge fields Word can handle.

You would see this limit if you used Words old spreadsheet converter to link in
the data source. Shouldn't see it otherwise, though...

If you activate "Confirm conversions on open" in Tools/Options/General. Then
choose the Excel file in the usual way. You should see a dialog box with a list
of connection methods. Which one is selected by default?

If you choose OLE DB, do you get more fields?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail