Mail Merge option

0 votes
128 views
asked Feb 9, 2016 in How To by mbs
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

1 Answer

answered Feb 9, 2016 by Admin
selected Feb 10, 2016 by mbs
 
Best answer

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

commented Feb 10, 2016 by mbs
thank you!

Let's Welcome our New Members

  • ras of Mechinas Ner Naftali - Apr 10, 2024

  • ckeller of MYY - Apr 03, 2024

  • Malka.eisenbach of YTT - Apr 02, 2024

  • eneuberger of JDBYYTT - Apr 01, 2024

  • cmayer of Bais Esther - Apr 01, 2024

  • astauber of JLS - Mar 27, 2024

  • yaakova of Bnos Menachem - Mar 26, 2024

  • GElefant of YGZM - Mar 21, 2024

  • bmiskin of Yeshiva Gedolah Zichron Moshe - Mar 20, 2024

  • cungar of Kollel Chatzos - Mar 18, 2024

...