Access 2007 Mail Merge question

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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.
 
Joined
Jul 29, 2001
Messages
21,334
You could also do this in a report directly in Access bypassing Word altogether.
 
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top