Solved

nesting logic in word excel mail merge

Posted on 2011-03-22
4
215 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:dkoliver
4 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 250 total points
ID: 35197075
I would put an IF field for each status after the greeting line, with the rest of the text in the True part:

{IF { MERGEFIELD Status } = "beginning" "On behalf of Dr. Jeff Kenkel, I would like to invite you to participate in the Aesthetic Society’s Committee for 2011/2012.

...

Thank You!”}

{IF { MERGEFIELD Status } = "continuing" "As incoming President of the Aesthetic Society, I would like to take this opportunity to thank you for serving as a member

...

P.S.  As a reminder, the Committee will be meeting on  details."}


Then within each block, at the point where the meeting details would go, you can put another IF field, this time testing for the 'no meeting' text, and putting the details, e.g.

{ IF { MERGEFIELD meeting } = "There is no scheduled meeting for this committee" "" "The current Committee will be meeting on { MERGEFIELD meeting } You are welcome to attend this meeting if your schedule allows."}


0
 

Author Comment

by:dkoliver
ID: 35219137
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!
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35821684
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question