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