Mail Merge Address Block Formatting

I'm using Mail Merge to get hundreds of contacts into a word label template and mailing print labels.

When the street address has 3 lines (instead of the typical 2) the city, state part of the address is being pushed down an extra return. 

The address previews fine, but there's an extra return when it's all completed - see photo using Walmart Headquarters as an example. (I've removed the name field/line to protect privacy)

Image

This is hard to explain and search for, I'm on a quick deadline and hoping someone may be able to help? 

Answer
Answer
You'd do better to insert the actual mergefields you require, rather than relying on the AddressBlock. For the empty line suppression using mergefields, see the topic on that subject in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
or:
http://windowssecrets.com/forums/showthread.php/163017-Word-Mailmerge-Tips-amp-Tricks
Cheers
Paul Edstein
(Fmr MS MVP - Word)

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 14, 2025 Views 3,426 Applies to: