Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2007 Mail Merge puts in a space for empty fields from Excel 2
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, |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2007 Mail Merge Labels skips fields using update fields | Mailmerge | |||
merge data from excel puts too many decimal values on my template. | Mailmerge | |||
Using if fields in mail merge to ignore empty fields | Mailmerge | |||
Empty Mail Merge Fields | Microsoft Word Help | |||
Empty Mail Merge Fields | Microsoft Word Help |