Mail Merge option

Question

When I do a mail merge and I want to use the "Student Call Name" field, but if that field is empty, I want the regular name to come up, does anyone know how to this function in excel? Thank you

Answer 1

Download this word document. Open and copy and paste the one you need. We have there the English and Hebrew call name. This uses words IIF field.

https://JLSSolutions.com/kb/images/CallName.doc

Comments

thank you!