Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2015, 01:44 AM
DIYman DIYman is offline Extra space in address field but no blanks in source Windows 7 64bit Extra space in address field but no blanks in source Office 2013
Novice
Extra space in address field but no blanks in source
 
Join Date: Sep 2015
Posts: 5
DIYman is on a distinguished road
Default Extra space in address field but no blanks in source

Hi All,
This is my first post so It may be in the wrong place.
I'm using word 2013. My source data is an Excel workbook with the list filtered via mail merge. There are no empty cells in the filtered list. However my merge document creates a space between the name and the address in the AddressBlock. Can you advise how to correct this. When I used alt F9 originally there was a space showing in the code. I deleted this but the space remained.
The only matched fields in address block are First Name, Surname and address. Sample result
John Doe

Main Street

I've used mailmerge in word 2003 and did not find this problem
I don't know how to paste the "detailed or open" address block
Thanks in advance



Code:
«AddressBlock»
Reply With Quote
  #2  
Old 09-17-2015, 02:23 AM
macropod's Avatar
macropod macropod is offline Extra space in address field but no blanks in source Windows 7 64bit Extra space in address field but no blanks in source 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

Instead of using the AddressBlock field, which has very limited abilities, you should insert the actual mergefields that comprise the addressing. Quite possibly, though, the gap is due to paragraph formatting - check the space before/after settings for the paragraph you're adding the AddressBlock field to.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-17-2015, 03:07 AM
DIYman DIYman is offline Extra space in address field but no blanks in source Windows 7 64bit Extra space in address field but no blanks in source Office 2013
Novice
Extra space in address field but no blanks in source
 
Join Date: Sep 2015
Posts: 5
DIYman is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Instead of using the AddressBlock field, which has very limited abilities, you should insert the actual mergefields that comprise the addressing. Quite possibly, though, the gap is due to paragraph formatting - check the space before/after settings for the paragraph you're adding the AddressBlock field to.
Thank You macropod, I've done as suggested and it seems OK on my test sheet.
I've checked paragraph settings and they are set (from original effort to solve this) at single line spacing and zero before and after spacing. However I don't understand if this feature is "designed for the job" why it doesn't seem to work properly.
Reply With Quote
  #4  
Old 09-17-2015, 03:19 AM
macropod's Avatar
macropod macropod is offline Extra space in address field but no blanks in source Windows 7 64bit Extra space in address field but no blanks in source 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

Without seeing your mailmerge main document, I can't say with any certainty why the AddressBlock field was generating the output concerned.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extra space in address field but no blanks in source How to make it highlight blocks of text (words) without highlighting extra space @end seortm Word 3 03-30-2015 08:12 AM
Extra space in address field but no blanks in source An html link from Excel works, but now there is too much extra space in the cell njweatherdon Word 2 09-22-2014 09:06 PM
Extra space in address field but no blanks in source extra space when I cross-reference a table or figure Toto Word 1 06-07-2014 03:51 PM
extra space before equation Nice2007 Word 1 04-27-2012 05:05 PM
Extra space in address field but no blanks in source Slight extra space between lines. lucadelcarlo Word 1 04-23-2011 04:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft