Need help with Word 2007 mail merge. Hard to explain.

This may or may not be a word problem. It may be something that can be accomplish in Access.
I am doing a mail merge in word. The mail merge may produce 1 sheet or it may produce 10 sheets, depending on the amount of fields it needs to print. Example: I need to print coupons. One person may have 10 and another may have 100. The way I have been doing this, (and it is time consuming), I create an Access file with all the fields. Then I merge them into a Word doc. I have 12 coupons that will print to one sheet. The coupons with data, (all different), will print the amount on them and the fields that have no data will print VOID on them. I would like to know if there is a way to print only coupons that contain the data and the ones that have no data would just not print at all?

I do have a query in ACCESS to run these. Let me try to explain further. I have to print coupons. I have set up a word doc with 12 coupons per page. In the ACCESS database I have 1000's of records. Each record has different dollar amounts and each record will have different amounts of coupons. They may have 10, 15, 50, or 100 coupons. The dollar amounts vary from $2.00 to $5.00. In the fields with no dollar amount I have a VOID. Lets say record one has 10 $2.00 coupons and 10 $5.00 coupons. That is 20 coupons total. So I would need one full sheet of coupons and then 4 coupons, on the second sheet, that will have the word VOID on them. I would like to have the voided coupons not print at all. Just a blank space. I guess I am asking, is there a way to code the doc so that if it has a void in the field, then just don't print anything. Am I making any sense?

Right. I do not want the VOID coupons in the mail merge. But the document is designed to print 12 coupons per page. I need it to print just the coupons that have a dollar value. If it is a VOID coupon I do not want to print the coupon at all.

Yes I will have 20 entries for 20 coupons. If you know another way to do this, PLEASE let me know. It takes a lot of time to enter all this. I know very little about using code in ACCESS. I would love it if there is a way to set up an access field that say this guy has (5) $2.00 coupons and (1) $3.00 coupon and then in the mail merge it will print only (5) $2.00 coupons and (1) $3.00 coupon and the rest of the sheet is blank. Without a pot load of code. Any ideas?

Yes to client base. I do the two tables. One with names and addresses and the other one with the coupon amounts. Problem is because I set up the document with 12 coupons per page, it still prints the blank coupons, that is why I have to have VOID in the coupons the client is not entitled to. The coupon has an area with the dollar amount in it. So if it has no dollar amount then it prints VOID. Is there a way in word to design one coupon, then have it print the amount of coupons needed? At this point the database is not my biggest concern. I would like to streamline it at some point. It is time consuming but it works. I did leave out the fact that the coupons also have the clients name & address and other info on them. Don't know if that make any difference.

Have not worked on it yet. Will on Monday at work.

Ok, I'll give it a try and see what I come up with. Thanks for your help. I'll let you know what happens.