#1
|
|||
|
|||
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). |
#2
|
||||
|
||||
It would be simpler if you reordered the data as attached and created a simple many to one mail merge with the attached certificate.
To achieve this you need Merge Many To One. Or if you want separate certificates, the same modified data file will do that also as a standard letters merge. However having all the dates on one certificate seems to make more sense.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
merge excel |
|
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 |