mail merge (?) on certain rows of sheet with access records included too?

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?

I've been thinking more about this and it seems that I should be able to do it if I can just get a list of the room numbers I need to query the database on.

How can I make a list of room numbers that only have the appropriate task for the day, with out blanks in between?

Thanks, that helps.

I managed to get that sub to delete rows, but not really the right ones...

In my sample data, one string to search for is actually "Full Clean". If I use the following code:

Please Login or Register  to view this content.

it will delete all the rows that do not have "Full Clean" in Column B, however it leaves all the rows with blank Column B. If I try also test for and delete rows that don't contain two possible strings ("Full Clean" "Stay"), I get some incorrectly deleted rows, and keep the blanks again.

Thoughts?

If I run the code multiple times it will eventually delete the blank rows.

Ahh, I need to run the loop up from the bottom.

Please Login or Register  to view this content.