I have a complicated if statements in my mailmerge. When I processed it - it
came out incorrectly....can someone help?
This is what I wrote:
{ifΒ«RESONΒ»= BKREM to purchase a Book of Remembrance. {ifΒ«RESONΒ»= CEMC
for the cemetery care program. {if(Β«RESONΒ»= COF to support the
Celebration of Freedom. {ifΒ«RESONΒ»= COT to support the Climate of Trust
program. {ifΒ«RESONΒ»= COTR to welcome the FSU delegates at the annual
Climate of Trust Reception. {ifΒ«RESONΒ»= FOOD to purchase a food
parcel(s) to the FSU. {ifΒ«RESONΒ»= INHON in honor of NAME of HONOREE
{ifΒ«RESONΒ»= INKND for the in kind gift of NAME OF GIFT {ifΒ«RESONΒ»=
INMEM in memory of NAME OF PERSON(S) {ifΒ«RESONΒ»= KPPT to purchase a
Kippot. {ifΒ«RESONΒ»= MANNA for the Manna Program. {ifΒ«RESONΒ»= MJSCH
to support the Minsk Jewish School through the Bay Area Council.
{ifΒ«RESONΒ»= MOSTM to purchase a MOST magazine. {ifΒ«RESONΒ»= VILN to
aide the elderly in the town of Vilnius. {ifΒ«RESONΒ»= YADLY to support
the Yad LYad (Hand to Hand) Program. {ifΒ«RESONΒ»= YSF to support and aid
Yana Slobodova in her return to the United
States.}}}}}}}}}} }}}}}}.
I thought I did it correctly but apparently not....it comes out like this:
Thank you for your generous gift of $50.00, which we received on March 03,
2005 {ifVILN= BKREM to purchase a Book of Remembrance. {ifVILN= CEMC
for the cemetery care program. {ifVILN= COF to support the Celebration
of Freedom. {ifVILN= COT to support the Climate of Trust program.
{ifVILN= COTR to welcome the FSU delegates at the annual Climate of Trust
Reception. {ifVILN= FOOD to purchase a food parcel(s) to the FSU.
{ifVILN= INHON in honor of NAME of HONOREE {ifVILN= INKND for the
in kind gift of NAME OF GIFT {ifVILN= INMEM in memory of NAME OF
PERSON(S) {ifVILN= KPPT to purchase a Kippot. {ifVILN= MANNA for
the Manna Program. {ifVILN= MJSCH to support the Minsk Jewish School
through the Bay Area Council. {ifVILN= MOSTM to purchase a MOST
magazine. {ifVILN= VILN to aide the elderly in the town of Vilnius.
{ifVILN= YADLY to support the Yad LYad (Hand to Hand) Program.
{ifVILN= YSF to support and aid Yana Slobodova in her return to the
United States.}}}}}}}}}} }}}}}} Your continuing support means
a lot to us.
I want it to determine that if the RESON is "FOOD" then the text that will
be displayed will say "to purchase a food parcel" or if the RESON is "BKREM"
then the text should say "to purchase a Book of Remembrance"...and so
on...not sure where I messed up.
Please help - need to get this finished!!! =)
"Graham Mayor" wrote:
Insert a conditional field on the previous line e.g.
{Mergefield Addr1}{IF {Mergefield Addr2} "" "
{Mergefield Addr2}"}
Note the positions of the line break and the quote marks.
Field boundaries are inserted with CTRL+F9
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Sayali wrote:
Hi,
I need to create Labels using Mail Merge. I have the following format
for the labels
First Name Last Name
Addr1
Addr2
Phone Number
I wanted to know how to supress a line if the data for that entry is
not available. Say for example if Addr 2 is blank then I want the
output to look like
First Name Last Name
Addr1
Phone Number
But I am getting the output that looks like this
First Name Last Name
Addr1
Phone Number
I am new at this so I wanted to know if there is any way in which I
can suppress the empty line?
Thanx in advance
Sayali