Blank address lines in mailmerge

[Malcy]

I am trying to generate letters from ACC2003 db into Word2003. Reason for Word is so client can edit letters if required.
I have set up a maketable query to generate a temporary table in the Db and the mailmerge master document all formatted and pointed at the temporary table. I still need to get the automation running so that the letters merge and print on a command button.
My immediate issue is that the address lines are intentionally spread across 5 fields Addr1, Addr2, Addr3, Town, Postcode. Not all fields in every record are full, and with the query it would be impossible to eliminate fields on the chance they might be empty.
As a result my mailmerge has blank address lines which do not look professional.
Can anyone point me to how I might solve this given my proposed use - if it was a report then I have a little code module that neatly eliminates blank lines but I cannot see how I could integrate this into the mailmerge process.
Thanks for any help or pointers

 

[asather]

Malcy,

Is this the solution you are looking for?

I have had to employ it a few times myself.

 

[Malcy]

Thanks Andrew
That article did not in fact sort it but it did prompt a wider search and I found the solution. It turns out I had used "new line" at the end of each address line (to suppress extra spaces) but MailMerge only suppresses blank lines if it is "new paragraph" at the end.
Solution was to make each address line a new paragraph and then format the paragraphs over the address line so that there was zero extra space before and after.
Why it does it that way God only knows but thanks for leading me to the solution
Best wishes for a Good New Year