Coupon Finder/Creator

I want to advertise services that have not been used by my current clients. There are 4 tables Involved. JobType = List of all of our services Contacts = List of our customers Orders = All of the work previously done for the client Calls = Communication with the customer (we will store the coupons given here) I have currently created a Union Query (CouposAndServices) so that I can see all of the jobtypes used from orders and all of the coupons that have been given. What I need to do is Pull a jobtype that has not been used (or a coupon that has been sent in the last 6 months) at random from the remaining avaliable jobtypes and create a list for all of the customers so I can export that to excel for a mail merge. so Each line of the list would look something like this: ID,Name,Fname,Lname,Addr1,City,State,Zip,Coupon,CouponLocation We also need to write the Coupon that is currently being issued to the Calls table with the date so that we don't use the same coupon next time.