Thread: [Solved] Remove Carriage Returns in Address Block Merge field
View Single Post
 
Old 12-12-2017, 08:32 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
So your source data already have the returns in the field? If so, there's nothing the mailmerge can do about that. You'll need to either modify the data source or edit the output post-merge. Personally, I'd be inclined to modify the data source, breaking the street address, locality, zip & state into separate fields - which is how such data are normally maintained.

Your original post's mention of an 'address "block"' led me to believe you were using the AddressBlock field.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote