|
|
#1
01-11-2021, 03:03 AM
|
|||
|
|||
Conditional mail-merge by Excel cells
Hi everyone, I have attached sample Excel table, where in each row I have 1 person and then there are columns with different dates where it is marked if person was present at the class on that day (data.xlsx). Is it possible to create mail-merge, where each person in table would get certificate (ie. Certificate.docx) only for the dates where he/she was attending the class? So in the examples from my attached files John Doe would get 2 certificate letters (for 13. and 14. 10. 2020) and Jane Doe would get 2 certificate letters (for 12. and 13. 10. 2020). 
|
| Tags |
| merge excel |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Multiple Conditional formating within MS Mail Merge from Excel
|
SCOATS | Mail Merge | 3 | 06-05-2019 06:55 PM |
|
Conditional Text without Mail Merge
|
wvdh | Word | 3 | 10-05-2017 02:38 AM |
| I know nothing about mail merge, but need help with conditional statements | briyosa | Word | 1 | 03-27-2017 10:17 PM |
| Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
|
Conditional merge fields in mail merge
|
Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
Windows 10 
Office 2016
Threaded Mode