Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2021, 03:03 AM
ales.jamsek ales.jamsek is offline Conditional mail-merge by Excel cells Windows 10 Conditional mail-merge by Excel cells Office 2016
Novice
Conditional mail-merge by Excel cells
 
Join Date: Jan 2021
Posts: 4
ales.jamsek is on a distinguished road
Default 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).
Attached Files
File Type: xlsx data.xlsx (8.6 KB, 10 views)
File Type: docx Certificate.docx (11.9 KB, 7 views)
Reply With Quote
  #2  
Old 01-11-2021, 05:22 AM
gmayor's Avatar
gmayor gmayor is offline Conditional mail-merge by Excel cells Windows 10 Conditional mail-merge by Excel cells Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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.
Attached Files
File Type: docx Certificate.docx (12.1 KB, 7 views)
File Type: xlsx data2.xlsx (9.2 KB, 7 views)
File Type: docx Jane Doe.docx (12.1 KB, 6 views)
File Type: docx John Doe.docx (12.0 KB, 6 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
merge excel

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional mail-merge by Excel cells Multiple Conditional formating within MS Mail Merge from Excel SCOATS Mail Merge 3 06-05-2019 06:55 PM
Conditional mail-merge by Excel cells 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 mail-merge by Excel cells Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft