Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Use If Then Else in Word Merge (Word 97)

    I am merging from Outlook to Word. I have a First Name field and an Nickname field. In Word, I would like to say Dear Nickname (and if Nickname is blank use First Name). Anyone have an idea how to do this?

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use If Then Else in Word Merge (Word 97)

    Try this:
    Once you're finally In Word (I'm using Word97) via the mail merge command in Outlook, Click Insert Word Field > If...Then...Else... and fill in the criteria supplied in my attached picture. It seems to work for me, with my standard Outlook Nickname and First_Name fields.

    To get the MERGEFIELDs into the separate boxes, press Ctrl-F9 to get the braces {}, and type in 'MERGEFIELD xxxxx', where xxxxx is the field you want inserted.

    HTH<font color=red>Edited to show how to include the MERGEFIELDs into the dialog box</font color=red>
    Attached Images Attached Images

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use If Then Else in Word Merge (Word 97)

    Just to add one thing to Kevin's advice. When you're done doing this, press Alt+F9 to show field codes. It is useful to show the syntax for IF-THEN-ELSE fields so you can quickly type them. The syntax is:
    {IF ConditionExists "ThenDoThis" "ElseDoThis"}

    Cheers,

  4. #4
    New Lounger
    Join Date
    Jun 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use If Then Else in Word Merge (Word 97)

    Thank you soooo much for your response. It worked like a charm. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

  5. #5
    New Lounger
    Join Date
    Jun 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use If Then Else in Word Merge (Word 97)

    Thank you... Thank you... Thank you...

Posting Permissions

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