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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefanus Snyman - 24 Sep 2006 21:35 GMT

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!!

Reply to this Message

Cindy M. - 25 Sep 2006 12:58 GMT

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 :-)

Reply to this Message

Rate this thread: