SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Guru ripcurlksm's Avatar
    Join Date
    Aug 2004
    Location
    San Clemente, CA
    Posts
    859
    Mentioned
    0 Post(s)
    Tagged
    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?
    Attached Images Attached Images


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •