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),'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 :-(

hi martin

thank you for your reply, i appreciate
however: as i have indicated in the post above:

1..........cell with garbeld text (over 1000 characters).....................cell with garbeld text (over 1000 characters)....................

i have already tried this (adding a test of more than 255 characters in the first record
so the solution suggested on wordbanter forum doesnt solve MY problem

hope someone can help
thanks