asked on

nesting logic in word excel mail merge

Every year, committee members leave or begin or continue. Also every year, there is or is not a commiittee meeting.
All of these 6 possible conditions need an email communication. In excel or word, both programs being used in this mail merge, variables and repeating text blocks are possible. I do not know how to put it all together and need step by step instructions.
Example:
Member name status meeting
bob leaving No ->"a meeting of this committee is not currently scheduled"
dee continuing no
chuck Beginning yes ->meeting details included

Sample text and data are attached. Please help. Want every letter possiblility in 1 merge.
Thanks a lot!

Beginning-no-meeting-scheduled.docx
Beginning-meeting-scheduled.docx
leaving-no-meeting-scheduled.docx
leaving-meeting-scheduled.docx
continuing-no-meeting-scheduled.docx
continuing-has-a-meeting-schedul.docx
test-data-for-committee-merge.xlsx

ASKER CERTIFIED SOLUTION

GrahamSkan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dkoliver

ASKER

My pea-brain seems able to follow this - at least in theory.
I will play around with it and get back next week to let you know if I am able to execute on this method. Thanks Graham!

Tracy

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.