The problem that I am facing is that Word 2007 is adding spaces in a mail merge when there isn't a value from an excel document.
<<FirstName>> <<MiddleName>> <<LastName>>
I've placed spaces in between the template place holders to seperate the names. However, when a record doesn't have a middle name, there will be two spaces in between the first and last name. I remember previous versions of word removing the "extra" spaces in the past. However 2007 doesn't do this for me automatically, instead it adds an extra space when the datasource is blank/null.
you can also clicl on the paragraph icons in word, believe it's the second one from the default ( at work Now so i am not using 2007) but use at home. its the same thing when you try to type a regular document.
Actually this doesn't fix what I'm working with. However it does fix that extra line that is created when hitting the enter key. We had another fix, which is to change the style to use word 2003 instead of 2007. Thanks for showing me how to fix that the right way.
My problem comes from doing a mail merge from an excel list of addresses to several lables. The template is like so.
Where the underscore between the arrows represents one spacing since the arrows makes it hard to see them. Now when we merge the document with the data from excel, an extra space is created if for say middle_name is null or empty. How do I prevent extra spaces from showing up between field names. This use to not happen in Word 2003. Any ideas?
If your first and last name are in the same cell in excel and you try to merge into word using the "last name field" it will create an unnecessary indent space. MS Office thinks there should be a space there because it’s a last name and there is always a space between first and last.
Either separate the first and last name in excel and re-merge OR match the field to the “first name” in word and the space should disappear.
If it won't single space, HIGHLIGHT label or doc, go to FORMAT then PARAGRAPH and set spacing Before and After at zero and Single; go to Line Breaks and check the box next to "Keep Lines Together" have that be the ONLY box checked, hit okay.