I have what seems to me like a fairly complicated task I'm trying to achieve...

I have a spreadsheet (HK) that includes a list of room numbers (ColB) and tasks to perform that day (ColQ). I want to print off a page (currently a word doc), but only for the room numbers where the task is one of a few options ("Clean" or "Linen" or "Check"), and include on each instance the room number and task.

To further complicate things, I also want to connect to an access db (MT) and add into each instance of the template/mail merge document records with a matching room number.

I'd like to do all this from inside excel as the users are already printing opening and printing the HK spreadsheet, if possible.

Anybody got some help on how to achieve all this?