1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access 2007 Mail Merge question

Discussion in 'Business Applications' started by smurzil, Nov 29, 2011.

Thread Status:
Not open for further replies.
  1. smurzil

    smurzil Thread Starter

    Joined:
    Nov 29, 2011
    Messages:
    1
    I am needing help with a mail merge issue. I have my database in Access 2007

    Let's say I have two to tables. Table one consists of customers who have purchased items and their locations. Table two is of the items that were purchased by the customers. The two tables can be joined by their ID's. CID = ID

    Table 1
    Name Address ID
    Bob 123 Main st 502
    Kim 13 State st 503

    Table 2
    Item price CID
    pen $1.00 502
    key $0.75 503
    ball $3.25 502
    key $0.75 502

    I want to send letters out to the customers telling them what they have purchased, but I do not want to send multiple letters to the same customer if the have purchased multiple items. For example, Bob, has purchased three items. I only want Bob to receive one letter

    My question is...How can I join these two tables to make one mail merge and not send out a single letter to a customer who has purchase multiple items?

    Thanks.
     
  2. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    You could also do this in a report directly in Access bypassing Word altogether.
     
  3. uildriks

    uildriks

    Joined:
    Aug 25, 2007
    Messages:
    2
    First of all, you should probably change your data model because the way you do this now will include items sent at any time in the past. The normal solution for this would have three tables: Customer, Order and Orderlines - with their obvious meanings. An order would include a reference to the CustID, and each Orderline a reference to OrderId, creating one-to-many relations for both. There are no standard features in Access to mail merge the above, But this is possible using a - commercial - extension of MS Access called 4TOPS Mail Merge. How to create an email with PDF attachment using 4TOPS Mail Merge is a more complex example showing the combination of the mail merge in Word, conversion of the document to PDF and having it sent by email. The example is included in the demo database with the product.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1028971

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice