[SlowHnds]

Mail merge in Word 2007 data file is Excel spreadsheet 2007. When I merge the
document (Word 2007) with the data file (Excel 2007) and there is empty
fields in the data file, Word inserts a space. I don't want it to enter
anything.

field names in excel

Salute FirstName MidInital LastName Mail1 Mail2 location Prov Postcode

When I merge this to a document that is

Dear Salute FirstName MidInital LastName

Thank you for your ......


If the excel spread sheet contains a blank (null) field, when the word
document is merged it inserts a space. How do I stop this where the field is
empty don't put in anything, no space, just skip to the next field.

So I could get

Dear Simpson

Thank you for ......

......

Instead I get

Dear ___ (3 spaces) Simpson,