Hi folks;
Hey wow, first post! Probably the first of many judging by all the new challenges that keep cropping up in this project I'm working on... A huge dump of data came from the mainframe a few weeks ago, and my task is to root out all the data (mostly financial and there's a LOT) that doesn't add up and co-ordinate the account managers to sort out the holes. The mainframe dump was put into Access and mashed around until it made sense. I've now managed to boil the data that needs amending into a dozen or so fields with the discrepancies highlighted. These 10,000 records have been sorted back into the 100 or so account managers who were originally responsible for the accounts and placed in an Excel spreadsheet.

Now, here's my problem. I need to send each of these 100 account managers 1000 or so records to look into, amend, and report back on, and the whole thing needs to be done electronically. These are the methods I've considered, and I'd love it if some of you Excel pros could advise me on the most painless way:

1. Place the data into Word documents using mail merge fields. Email the Word docs out to the account managers (is there a way of saving each page under a unique filename?) and somehow extract the fields back into Excel when they're returned?

2. Use Excel itself as both mail merge client and data source, maybe using the built-in functions of Excel or Access to smooth the way when the data comes back.

What do we think? Anyone have any experience of this?

Thanks!