Results 1 to 1 of 1
Dec 10, 2009, 12:56 #1
- Join Date
- Aug 2004
- San Clemente, CA
- 0 Post(s)
- 0 Thread(s)
Microsoft Word Mail Merge -- Excel Database
Not really sure where to put this, mods feel free to move somewhere else if appropriate.
I am pulling info out of my database and inserting it into Microsoft Excel to use as a mail merge for a simple listing of companies. The problem is that I do not have all criteria for all companies, so for example if I didn't have an email in my example below, "Email:" would appear with a blank next to it. Is there any way to not show email if it is empty?
Here are two examples, in yellow, I dont have an email for Pepsi, so I would like to not show the "Email" field at all. In the next row, i dont have the "year" field and would like to hide the "Year" label.
How can I omit criteria such as "Email" and "Year" if they are empty?