Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Nov 2003
    Location
    St. Paul, Minnesota, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge using Access database (2000)

    I need to create mailing labels in Word using an Access data base. My problem is in the formatting. Not all recipients have spouses. Therefore, when I merge the data I get extra spaces between the first and last names for the people who do not have spouses. Is there a way to force a space only if there is data in a field? I need something like this:

    {FirstName}{^And}{^SpouseName}^{LastName}

    I tried inserting a space before the "and" in the database, but Word trims it off when it merges it. I could combine the "and" and the "spousename" fields to eliminate one spacing problem, but that would reduce the usefulness of my database.

    Any suggestions?

    Shelly Conlin

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail merge using Access database (2000)

    Try this:<pre>{ IF { MERGEFIELD SpouseName } = "" "" " And { MERGEFIELD SpouseName }" }</pre>

    As usual, you should not type field brackets { } yourself; press Ctrl+F9 to insert them.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge using Access database (2000)

    Found this on web... I think it is what you are looking for

    http://groups.google.com/groups?hl=en&lr=&...@phx.gbl&rnum=8
    Hope this helps... trish

  4. #4
    Lounger
    Join Date
    Nov 2003
    Location
    St. Paul, Minnesota, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge using Access database (2000)

    Worked like a charm. Thanks, Hans!

    Shelly

Posting Permissions

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