Good morning one and all!!!

I am in a bit of a quandry of how to approach my latest issue. I have an Access database that I need to create Word Mail Merges from.

I understand how to set up the merges, attach the data source, etc. What I'm confused on is the most efficient approach to determining what Word template to use. This is determined by looking at two fields in the database... for instance:

If Response_Count = 9 AND Scale_Label is not = "--" then the template used would be a specific one, if Response_Count = 9 AND Scale_Label = "--" then a different one would be used.

I have 18 different templates (soon to be even more unfortunately but I'll deal with that later, the concept will be the same!!!).

How in the heck do you look at the recordset to determine values in ADO? I am not using controls because (as you all will agree!) they were causing problems and not flexible enough.... However, connecting and manipulating in ADO is REALLY confusing me!! I have used some DAO before and it seems a little more straight-forward, but everyone has "ordered" me to use ADO!!! (of course, I did use some DAO on another form because it was easier and that was early on!!!!!).

Please advise. I have tried searching but haven't come up with anything yet! I thought I saw something about SQL Select Case before but can't seem to find it (may not have been this forum), but even so I'm not sure how to determine values for specific fields via ADO! If I can figure this out then Select Case in VB and calling a procedure is what I'm thinking would be best??? The field value will be the same for every record in the specified data table.

Thanks,
Mary