Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Columbus, Ohio
    Thanked 0 Times in 0 Posts

    Mail merge-2nd question (Word2000 sr1a))

    How do you not include a word that may not be needed, depending on a field?
    For example:
    I have a document that I use where the customer's name(s) are fields that I have inserted into my form letter. The fields are "Customer1" and "Customer2". The form letter starts out with a greeting, "Dear 'Customer1' and 'Customer2' ", The price is $100. ..........
    Problem: If I only have one customer (Customer1), the form letter reads "Dear 'Customer1' and The price is $100........ In other words, the "and" that is necessary with two customers' is not needed when there is one.


    I am new to this Mail Merge/form letter stuff.


  2. #2

    Re: Mail merge-2nd question (Word2000 sr1a))

    Hi Rick,

    You need to use an IF field. What you need would be something like:
    { IF { MERGEFIELD Customer2}<> "" "and { MERGEFIELD Customer2}" }

    Note that the curly braces are field braces and are inserted using <Ctrl F9>

    You can also click the "Insert Word Field" command on the Mail Merge toolbar to assist you with this.

    This article may be of interest to you as well:
    <A target="_blank" HREF=></A>

Posting Permissions

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