I am having a big problem. I have an Excel file with about 1,000 records. My main issue is that I am mail merging using Word.

I want to be able to create a new document for each change in Fax#. My goal is to create one document based on the Fax# so that instead of sending 1,000 individual faxes I can group the faxes and send them in batches...

Does this make sense...?

So instead of sending 5 faxes to Dr. Smith at 555-555-5555 I can create one seperate document containing those 5 pages that have a fax value of 555-555-5555. I cannot seem to figure this out.

Right now I am working with 1,000 page document and pulling up the fax printer. I have to specify the page #'s that I want to fax. I'm afraid that I will make a mistake and end up sending more or less pages that I intended...