Oh boy, what a problem to fix. Help!!

[slang]

I have a big problem. We have a large mail merge that populates letters to 2200 locations and then dumped into one large document. The girl with the mail merge document is on vacation so we do not have access to it and we need to be able to print selected pages from the main document based on a location number.

Example, Each location has one page in the main document with their location number in the second line. We have a list of all location numbers for each territory that we could use as a reference. The idea would be to have an input box that asked which territory you want printed and the code would look at each page for the location number and if it matched one in the territory chosen it would print it.

Is this even possible? It seems like it is asking a lot of Word.

The data would be similar to this..
Location # Territory #
6624 1
3498 1
8752 1
0275 2
9993 2
etc

[slang]

I started playing with some code and I can get it to look for the location number and when it does to print the page. But how do I get it to reference the list and do a search for each location number within the territory?
I am not familure with the word references at all. In Excel it wouldnt be a problem. Do I put them in a table and reference the elements?
:banghead: :dunno :think:

Thanks......

[slang]

The main problem is that the territory number is not included in the mail merge or main document. The code would have to look at a list that contained two columns (location # & territory #) and search for all location numbers within the territory chosen.

Confused yet? LOL

This is where I do not know how to reference this list to cycle through it or where to put it (in a table in the document, csv list, external data)?

When the person comes back from vacation I will make sure this reference is in the mail merge and it is on a share instead of locally.

Thanks for you help. It is appreciated....