View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Kevin Kevin is offline
external usenet poster
 
Posts: 85
Default Mail Merging: Omit Empty Fields?

I am pulling info out of my database and inserting it into Microsoft Excel to
use as a mail merge for a 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?

Company Name: company name
Email: email
Phone: phone