Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Excel cell filler for word merge document
I am using Excel as a database for letter mail merge to Word.
I have "first name", "middle initial", "last name" fiels in the merge document. Not all ppl have middle initials so Word is inserting an extra space in those letters. Is there a filler that I can put in those cells with no initial to keep Word from inserting that extra space? Thank you in advance for any suggestions. Shawna |
#2
|
|||
|
|||
Excel cell filler for word merge document
I found this, but do not know how to implement it:
The following conditional MERGEFIELD fields remove the blank space if the middle initial field is blank. For example, given the following fields in a mail merge main document, <<FNAME <<MI <<LNAME the following conditional IF field eliminates a blank space caused by an empty middle initial field: {MERGEFIELD FNAME}{IF {MERGEFIELD MI} < "" "{MERGEFIELD MI} "}{MERGEFIELD LNAME} "Shawna" wrote: I am using Excel as a database for letter mail merge to Word. I have "first name", "middle initial", "last name" fiels in the merge document. Not all ppl have middle initials so Word is inserting an extra space in those letters. Is there a filler that I can put in those cells with no initial to keep Word from inserting that extra space? Thank you in advance for any suggestions. Shawna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
How do I merge excel information with a word document? | New Users to Excel | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Merge and Center Disabled in Excel 2003 Document | Charts and Charting in Excel |