Hello all! I'm trying to streamline a document building process and using data from Excel to create the document. Instead of going back and forth and copy/pasting data I found out I can use Mail Merge! It's amazing for most things, but my question is can I use Mail Merge to compare two different data fields in Excel and then produce text based on whether the condition is true or not?

​

To provide context, what I want to do is:

If the Last_Day_in_Office (Excel Field) is the same as the Termination_Date (Excel Field), then "BLOCKTEXT1", otherwise "BLOCKTEXT2". To make things more difficult for myself, in BLOCKTEXT2 I want to distinguish between the data fields referenced.

BLOCKTEXT2 = "Blah blah blah last day in office will be Last_Day_in_Office. After Termination_Date blah blah blah"

An answer to this would really be appreciated. So far the only workaround I found was making the Excel spreadsheet more complicated by introducing a column that provides a Yes/No outcome if the dates are the same, and then using that one field in Word.

​

Thanks all!