Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: Ignore Blank Cells In Mail Merge

  1. #1
    Join Date
    2nd March 2008
    Registered Users

    Ignore Blank Cells In Mail Merge

    Hi All,

    I am using an excel file as a database of addresses, from which i will merge onto a standard word document.
    My issue is that i have (as the attachment shows):

    School Name/First Line Address/Second line address/Third Line address/Post Code

    Not all of the addresses have a second line address. How can i in a mail merge (in word) have it so that it ignores the second address line if there is nothing in it?
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by lowtusmaximus; March 3rd, 2008 at 01:02. Reason: add file

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    23rd September 2003
    Registered Users

    Re: Ignore Blank Cells In Mail Merge


    The answer is in the word doc, not the database.

    Try a shuffle around the help file.

    To prevent blanks lines with Microsoft Word fields such as IF, SET, and ASK, do the following:

    If a field (such as ASK or SET) has no resulting text, you can insert the field within the standard text. If you must place the field in a separate paragraph, format the paragraph mark () as hidden text. Before you merge the documents, clear the Hidden text check box on the Print tab in the Options dialog box (Tools menu).
    If text inserted by an IF field must be printed in a separate paragraph, include the paragraph mark in the field instructions. Insert the IF field in the main document; then, with field codes displayed, insert the paragraph mark within the appropriate set of quotation marks. In the following example, Word inserts the paragraph mark that follows "brochure" only if the text is printed.
    { IF { MERGEFIELD Product } = "Pasta" "We have expanded our line of pasta products. Please see the enclosed brochure.

    " " " } Thank you for your order.


    Excel Video Tutorials / Excel Dashboards Reports

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Running a report in Access and ignore blank cells
    By jonsmile in forum Excel and/or Access Help
    Replies: 1
    Last Post: February 17th, 2005, 22:05
  2. Replies: 1
    Last Post: December 2nd, 2004, 12:21
  3. ignore blank cells /& match w/multiple results
    By kimberly in forum Excel General
    Replies: 2
    Last Post: July 6th, 2004, 12:05


Posting Permissions

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