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.
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!