ripcurlksm
12-10-2009, 12:58 PM
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 example screenshots, 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.
Example:
http://www.webdeveloper.com/forum/attachment.php?attachmentid=13301&stc=1&d=1260471400
How can I omit criteria such as "Email" and "Year" if they are empty?
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 example screenshots, 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.
Example:
http://www.webdeveloper.com/forum/attachment.php?attachmentid=13301&stc=1&d=1260471400
How can I omit criteria such as "Email" and "Year" if they are empty?