Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Suzanne Suzanne is offline
external usenet poster
 
Posts: 53
Default Word 2007 Fix for 255 Character Limit

Is there a fix for Word 2007 255 character limit (mail merge Excel 2007 to
Word 2007 document).

I cannot split the Excel field (the field is a comment field and is
sometimes, not always, over 255 characters); I have checked the Word advanced
option box "confirm file format conversion on open" afterwhich I closed and
re-opened Word.

The comment field is still truncating at 255 characters.

Thanks -- Suz
  #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 Word 2007 Fix for 255 Character Limit

You need to make sure that the (to be sure) first record in your data source
contains more than 255 characters as otherwise, field may not be recognised
as being of the type that does contain more than that number of characters.

The field type is determined by consideration of the first half dozen or so
records, but to be sure, it is best to make sure that the first one is such
that the correct type will be taken into account.

--
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
"Suzanne" wrote in message
...
Is there a fix for Word 2007 255 character limit (mail merge Excel 2007 to
Word 2007 document).

I cannot split the Excel field (the field is a comment field and is
sometimes, not always, over 255 characters); I have checked the Word
advanced
option box "confirm file format conversion on open" afterwhich I closed
and
re-opened Word.

The comment field is still truncating at 255 characters.

Thanks -- Suz


  #3   Report Post  
AaronRamsdale AaronRamsdale is offline
Junior Member
 
Posts: 1
Default

Maybe it is the mistake in Word you can redo and split again. fall guys
  #4   Report Post  
stevenmbrun stevenmbrun is offline
Banned
 
Posts: 4
Default

Very interesting post, thank you
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
Hyperlink Character limit RSC Microsoft Word Help 5 November 3rd 14 06:24 AM
Character limit LMB New Users 4 December 2nd 05 01:35 PM
Word 2000 autocorrect or autotext character limit mhillig1 Microsoft Word Help 1 February 16th 05 09:59 PM
Sql Query: 255 character Limit Mark Olbert Mailmerge 2 January 31st 05 07:33 PM
255 character limit in Word mail merge Gibson Mailmerge 1 December 7th 04 10:36 AM


All times are GMT +1. The time now is 06: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"