Reply
 
Thread Tools Display Modes
  #1   Report Post  
Giolina Giolina is offline
Junior Member
 
Posts: 1
Default mail merge (word 2010) cuts off the text after 255 characters

hi

this is located in SHEET1 of the Workbook:

No.............................HEADER-A................................................. ........HEADER-B......................................
1..........cell with garbeld text (over 1000 characters).....................cell with garbeld text (over 1000 characters)....................
2..........................Title_of_Text-1................................................. .......Text-1.......................
3..........................Title_of_Text-2................................................. ........Text-2.......................
4..........................Title_of_Text-3................................................. .......Text-3.......................
5..........................Title_of_Text-4................................................. .......Text-3.......................

then there are 13 other sheets in between

then this is located in SHEET14:

FORMULA: =IF(B3="H",IFERROR(IFERROR(IF(SEARCH("Lie*",C3),'S HEET1'!$B$2),IF(SEARCH("Seh*",C3),'SHEET1)'!$B$3)) ,""),IF(B3="PS",IFERROR(IFERROR(IF(SEARCH("Lie*",C 3),'SHEET1'!$B$4),IF(SEARCH("Seh*",C3),'SHEET1'!$B $5)),""),""))

It works fine in excel: it takes the 4 different texts according to the condition of the formula and inserts it in another sheet

THE PROBLEM:

when i run a mail merge: the text appears cut off after 255 characters

pleas help
i've searched for an answer so much ...dont know what to do :-(
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
Mail merge cuts off some text, how do i fix this? k&p Microsoft Word Help 3 May 4th 23 08:47 AM
SQLStatement exceed 255 characters in word mail merge using ms accessdatabase ashish taralekar Mailmerge 4 December 31st 07 10:38 AM
How to merge a memo field greater than 255 characters? Orbid Mailmerge 1 June 1st 05 11:12 AM
Word Mail Merge with QueryString longer than 255 characters Sebastian Martinez Mailmerge 5 February 7th 05 02:13 PM
How do I mail merge fields exceeding 255 characters from Excel to. martinenatasha Mailmerge 1 January 27th 05 05:17 PM


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