Mailmerge - remove extra spaces?

[FRrogoy]

I'm doing a mailmerge using address info from an Access table. The problem I'm having is the extra spaces between fields when one of the fields has no data, for example <<Middle_Name>>. It looks really bad on the 2nd line where the first field <<State_Prefix>> doesn't occur most of the time. So the line is indented one space.
If I leave the spaces out (in Word) the fields jam together. I tried adding a trailing space to the data, but it gets stripped out somewhere. The Addresses are for official positions, following the Civilian Models of Address rules, so they have more fields than the Word Address block wizard will allow.
Using MSWord 2002

Frank

 

[FRrogoy]

Thought I was stumped after 3 hours of trying to get this to work! Did a few minutes more research after I posted this thread and found an excellent article on how to do it.
It's at:

http://word.mvps.org/FAQs/MailMerge/MMergeIfFields.htm

Frank