Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Removing Blank Spaces in Merges
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing spaces | Mailmerge | |||
Removing Spaces with Replace | Microsoft Word Help | |||
Removing blank spaces and "" marks | Microsoft Word Help | |||
Searching for spaces and removing them | Microsoft Word Help | |||
Removing Unwanted Spaces | New Users |