Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Conditional Mail Merge (2002/SR1)

    We are having a one time, week long event. All the information is contained in an Access Database. I want to send out a confirmation letter to all participants by using Mail Merge in Word. One of items to confirm is whether or not they are planning to come to a dinner that we are having during the week and how many are attending.

    I have the dinner attendance field in Access set up as a Yes/No. When I use this field in Word, it comes across as True/False, which I don't understand. What I want to be able to do is put in a condition that if they are attending the dinner, the letter also shows how many adults and children are attending, if they are not attending, it stops right there and doesn't deal with attendance numbers. (what I have in my letter right now is whether or not they are attending and then a sentences right after that says "If you are attending, you will have 2 adults and 1 children." Seems kind of clumsy, also, don't know how to set it up for singular and plural, which can change on every letter.)

    I should note that I only have to send out about 75 letters, so I can Mail Merge to New Document and then use Find and Replace to get what I want. Just seems like there should be a way to do this automatically. Any ideas on how to do this in Word? Thanks for any help.

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Conditional Mail Merge (2002/SR1)

    Although merge has changed in XP, so I don't know where anything is, I read recently on this board that there is an option somewhere to make the insertion of some data conditional on other data. This might not be enough, if you also have static text that needs to be made conditional. In that case, you can manually wrap the additional sentence

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Conditional Mail Merge (2002/SR1)

    Thanks for the suggestions. I ended up just creating 2 letters, one for those that are going and one for those that aren't, then using the Find and Replace to change the items I needed. One of these days I will have to look into a better way, when I have time. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    The changes in merge for XP have been a real struggle. Still trying to figure it out. Last night I was trying to figure out how to filter the data, that was a lot of fun! Then, when I clicked on ADVANCED, it took me to the old filter screen, which I thought was real simple to use. Ah, progress. Oh, and after I filtered my records to show all the ones that were TRUE, I couldn't figure out how to get the ones with FALSE back. Wouldn't you think that ALL would show all the records? Guess not, had to re-attach the data source to get them back.

    Thanks again for your help.

Posting Permissions

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