mail merge (word 2010) cuts off the text after 255 characters

[Giolina]

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),'SHEET1'!$B$2),IF(SEARCH("Seh*",C3),'SHEET1)'!$B$3)),""),IF(B3="PS",IFERROR(IFERROR(IF(SEARCH("Lie*",C3),'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 :-(

 

[Lisa Wilke-Thissen]

Hi,

"Giolina" wrote

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

have a look at these articles:

http://www.msofficeforums.com/mail-merge/10103-mail-merge-more-than-255-characters.html
https://groups.google.com/forum/?fr...soft.public.word.mailmerge.fields/FN_eCMiv490