The period shoudd go after the final closing brace of the fields however you
do it.Try starting with this:
{ MERGEFIELD PRIZE1 } ({ MERGEFIELD Ticket1 \#000000 }){
IF { MERGEFIELD PRIZE2 } '"' "; { MERGEFIELD PRIZE2 } ({ MERGEFIELD
Ticket2 \#000000 })" "" }{
IF { MERGEFIELD PRIZE3 } '"' "; { MERGEFIELD PRIZE3 } ({ MERGEFIELD
Ticket3 \#000000 })" "" }{
IF { MERGEFIELD PRIZE4 } '"' "; { MERGEFIELD PRIZE4 } ({ MERGEFIELD
Ticket4 \#000000 })" "" }.
but extend it to the number of tickets you need
--
Peter Jamieson
http://tips.pjmsn.me.uk
"123.littlestar" wrote in message
...
I have about 10 merged fields (not all containing data) but I need the
sentence to end with a period. If I use the If..Else function then I get
about 8 periods at the end of my sentence for each blank field. If I
place
the period oustide the the function of the 10th merged field then I get
about
8 spaces before the period.
The formula I'm using is:
{MERGEFILED "Prize1"} ({MERGEFIELD 'Ticket1"\#000000}){IF {MERGEFIELD
PRIZE2} '' ";" "."}
This goes on for about 10 repetitions with different Prize Field numbers.
Any insight would be appreicated.