Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    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.

    Help!!!

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

    Rick

  2. #2
    BAM
    Guest

    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=http://www.mvps.org/word/FAQs/MailMerge/MMergeIfFields.htm>http://www.mvps.org/word/FAQs/MailMe...geIfFields.htm</A>
    ~~~~~~~~~~~~~~~
    Cheers!

Posting Permissions

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