View Single Post
 
Old 04-09-2014, 12:54 PM
Licos101 Licos101 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Apr 2014
Posts: 2
Licos101 is on a distinguished road
Default Mail Merge Empty Data Field

So i have a small issue. I am doing a mail merge for a letter with a number of different records all at once. The layout is as follows:

Dear <firstname> <lastname>
<company name>
<Address>

Not all the records contain a company name. What I would like to do is when the company cell is empty in the excel merge spreadsheet for word to remove that line all together rather than giving me an error or leaving it blank.

Can someone let me know if this is possible and how i can go about it.
Reply With Quote