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.

Has anyone else seen this happen?

Thanks in advance

Before you start your merge, do the following:

1. Right click any white space in your document and select Paragraph

2 The Paragraph properties will pop up.

3. Select “Don’t add space between paragraphs of the same style”

4. Click OK, Continue your merge.

I noticed that I can also default that setting for future documents.

Thanks I'll try it out.

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.

<<first_name>>_<<middle_name>>_<<last_name>>

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?

Thanks

You might have to use an IF field

{ IF { MERGEFIELD Title } = "" "" "{ MERGEFIELD Title } " }{ IF { MERGEFIELD FirstName } = "" "" "{ MERGEFIELD FirsName } " }

So if title is blank, add nothing, if not, title and space AFTER. The double quotes acts as a NULL-SPACE "" where " " would be a space.

You could also do a Find and Replace for double spaces, in find press space bar twice, in replace press once or leave blank.

If your using Excel for the data source, Insert a column and name the field "Full Name." Fill down the column with the following formula:
hope this helps.