• Mail Merge (Access 2000)

    Author
    Topic
    #378316

    Yikes! I went to a wonderful seminar for Access a couple of weeks ago. I learned a lot new things about Access, one of which is, using the mail merg feature.

    I set up an introduction letter for our Sales Representatives here at work. It was working great until I went to print my second batch of letters. The first batch keeps coming up.

    I have the query set up with check boxes.
    Yes – Send An Introduction Letter
    Yes – Introduction Sent.

    The query condition is Send = Yes AND Sent = No.

    Any advise you can give will greatly be appreciated.

    Viewing 0 reply threads
    Author
    Replies
    • #625877

      Questions:

      • Are you doing the merge in Word with Access as the data source?
      • Is the query the data source for your merge?
      • Have you run an update query to change the Introduction Sent field to YES for the first batch?
        [/list]Hopefully one of those questions will help to resolve your problem – if not please post more details and we will try our best to help.
    Viewing 0 reply threads
    Reply To: Mail Merge (Access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: