Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Teresa Teresa is offline
external usenet poster
 
Posts: 64
Default Merging more than 255 columns of data

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!
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merging more than 255 columns of data

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!


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I merge columns without merging rows? johnnychips Tables 5 April 21st 23 05:01 PM
Some data Merging as Zero, not the text in the data MaxArk[_22_] Mailmerge 2 April 12th 10 01:39 PM
My data is not merging as it appears in my data source Mary Mailmerge 1 September 21st 07 05:03 PM
Mail merging multiple columns to a wrod document bishop Mailmerge 1 January 25th 07 09:46 PM
mail merging multiple columns with varying number of rows troll_mage Mailmerge 1 November 10th 05 06:42 PM


All times are GMT +1. The time now is 03:31 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"