Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Claudia in DC Claudia in DC is offline
external usenet poster
 
Posts: 1
Default Problems merging Excel data into Word €“ cutting off at 255 charact

I have a Word document with 111 merge fields. The data is in Excel, and some
of the fields are long paragraphs. All are merging correctly, except for
just two fields, which cut off at 255 characters. I have Office 2007,
although this problem also happened when I had Office 2003. The data with
this issue is in the 74th and 97th columns of my Excel worksheet.

It seems strange to 100% be working except for just two fields. Any
advice/thoughts?

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Problems merging Excel data into Word €“ cutting off at 255 charact

My guess is that if you look at columns 74 and 79, the first 8 cells in
each of those columns will /all/ have 255 characters or fewer. Try
making just /one/ cell in the first 8 cells in each column have more
than 255 characters.

Peter Jamieson

http://tips.pjmsn.me.uk

On 15/01/2010 16:46, Claudia in DC wrote:
I have a Word document with 111 merge fields. The data is in Excel, and some
of the fields are long paragraphs. All are merging correctly, except for
just two fields, which cut off at 255 characters. I have Office 2007,
although this problem also happened when I had Office 2003. The data with
this issue is in the 74th and 97th columns of my Excel worksheet.

It seems strange to 100% be working except for just two fields. Any
advice/thoughts?

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
Problems with merging Excel and Word Benedikte Mailmerge 2 June 11th 09 07:52 AM
Problems Merging Data from Excel to Word for MAC AndyC812 Mailmerge 5 June 12th 08 08:34 PM
Problems merging with Excel cew47 Mailmerge 2 June 6th 08 10:42 PM
Problems merging lables from Excel to Word Fadeza Mailmerge 3 May 15th 06 10:23 PM
Merging data from Excel to Word Paige Microsoft Word Help 2 March 22nd 06 05:59 AM


All times are GMT +1. The time now is 08:51 AM.

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

About Us

"It's about Microsoft Word"