I am running an mail merge program, where I need to merge certain fields. I have done these in the past. Just to add on these, I have to print certain text based on the value of the field in MS Excel. For Example,
MS EXCEL
<<Column8>> <<Column9>> <<Column10>>
Record1 Y N Y
Record2 N N N
Record3 Y Y Y
MS Word Merged Email
Record1 Hi, blah blah blah
<<Column9>>
<<Column10>>
Record2 Hi, blah blah blah
Record 3 Hi, blah blah blah
<<Column8>>
<<Column9>>
<<Column10>>
But when I use and IF_THEN_ELSE, it gives me an blank space.Please advise. Thanks.