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