I am trying to create a table using mail merge. Each row of the table is created by a different set if/then/else statements. I am unable to remove the carriage return between the rows. Can someone please tell me how to remove the carriage returns? I can
not simply delete the carriage returns. They are fixed!
Below is my mail merge code in Word 2010 (
{ IF { MERGEFIELD T1_XYX } = "grp1" "" {IF { MERGEFIELD T1_XYX } = "grp3" "" {IF { MERGEFIELD T1_XYX } = "grp6" "" {IF { MERGEFIELD T1_XYX } = "" "" "
{MERGEFIELD T1_First_Name } | { MERGEFIELD T1_Last_Name } | { MERGEFIELD T1_XYX } |
{MERGEFIELD T2_First_Name } | { MERGEFIELD T2_Last_Name } | { MERGEFIELD T2_XYX } |
{MERGEFIELD T3_First_Name } | { MERGEFIELD T3_Last_Name } | { MERGEFIELD T3_XYX } |
{MERGEFIELD T4_First_Name } | { MERGEFIELD T4_Last_Name } | { MERGEFIELD T4_XYX } |
Below is my Excel file that I'm merging with the Word doc.
T1_First_Name | T1_Last_Name | T1_XYX | T2_First_Name | T2_Last_Name | T2_XYX | T3_First_Name | T3_Last_Name | T3_XYX | T4_First_Name | T4_Last_Name | T4_XYX |
Fred | Flinstone | grp4 | Wilma | Flinstone | grp3 | Pebbles | Flinstone | grp4 | Dino | Flinstone | grp5 |
Barney | Rubble | grp2 | Betty | Rubble | grp4 | BamBam | Rubble | grp1 | |||
Betty | Green | grp5 |
Below is what the merged file looks like in preview
Fred | Flinstone | grp4 |
Pebbles | Flinstone | grp4 |
Dino | Flinstone | grp5 |
When I turn the "show formatting symbols" ON I see there are carriage returns between the rows but Word will not let me delete them. How do I reformat so there are no spaces in between the rows???
Thank you.