[Teresa]

We are trying to merge an Excel file with 416 columns of data into a word
document, but the Word doc can only see 255 columns. Is there a way to do
this? If not, is there some way to append two word documents without cutting
and pasting?
Thank you kindly!

[Doug Robbins - Word MVP]

You will need to save the worksheet in *csv (comma separated values) format
and in Word, you will need to turn on the option for "Confirm file format
conversion on open" by going to Office buttonWord OptionsAdvancedGeneral,
and then when you attach the data source to the mail merge main document,
click on the Show All box after selecting the data source and then in the
Confirm data source dialog that appears, select the Recover Text from Any
File via Converter (*.*) method.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Teresa" wrote in message
...
We are trying to merge an Excel file with 416 columns of data into a word
document, but the Word doc can only see 255 columns. Is there a way to do
this? If not, is there some way to append two word documents without
cutting
and pasting?
Thank you kindly!