Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
123.littlestar 123.littlestar is offline
external usenet poster
 
Posts: 1
Default Removing Blank Spaces in Merges

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing spaces Christine Mailmerge 7 February 11th 08 07:33 PM
Removing Spaces with Replace ExcelMonkey Microsoft Word Help 1 January 17th 08 02:40 AM
Removing blank spaces and "" marks Virg Microsoft Word Help 5 February 24th 07 08:44 PM
Searching for spaces and removing them dean-nie Microsoft Word Help 5 January 19th 07 08:57 AM
Removing Unwanted Spaces Chris New Users 3 March 12th 05 09:45 PM


All times are GMT +1. The time now is 11:18 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"