Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    solving various name formats in mail merger (2003)

    In our Outlook 2003 data we have three different name formats, the data is in the following fields.
    1. John Doe: first= John, last= Doe
    2. John and Mary Doe: first= John, Spouse= Mary, Last= Doe
    3. John Doe and Mary Smith: first= John, last= Doe, spouse= Mary Smith

    We are trying to figure out how to construct a merge field so letters and envelopes will print all these names correctly ie:
    John Doe, John and Mary Doe, John Doe and Mary Smith.

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: solving various name formats in mail merger (2003)

    I think you will need another field to determine whether the surname is shared. Any other solution must count the number of words in the spouse's field and won't cater for compound names of the spouse such as Mary Anne or Billy Joe Bob.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: solving various name formats in mail merger (2003)

    As Andrew has said, I think you need to create another field. I would break the first & last name of both the husband & the wife into separate fields. That way you can use IF statements to test whether the wife field is blank, has the same last name as the husband or has a different last name to the husband. Depending upon the results of the IF statements, you can then format your letters to print the different combinations.

    Please post back if you need help with the IF statements.

    Regards,

    Matthew

Posting Permissions

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