Thom,
I'm not sure where you'd set it up but couldn't you simply build a special email address for Outlook, setup a folder for each customer within Outlook that would actually point to the customer folders you were talking about for each customer, setup an "on arrival" rule, and have SQL Server include that in the Blind Copy address?
Honestly, my knowledge of Outlook/Exchange isn't great, so not sure. If the folder needs to be set up manually, that'll be a problem as we have over 400,000 distinct customer references (not including their individual policies references, which they can have many of). Yes, not all of those clients/policies will be current, but it's still the large portion will be.
Hmmm... ok. BCC them to a common email address and have them save to a common folder. Then have someone write a "post processor" that regularly sweeps that common folder for some indication in the messages (TO email address) to figure out which folder to move them to. I've never opened a .msg file as a binary to see what's going on but it may be somethings as simple as a DOS FORFILES command or maybe a "simple" Powershell script that could do such a discriminatory move of the files.
I do know that .msg files can be saved (i.e., you can save an Outlook email as a .msg file to a folder). So this post processor might actually be the way to go.
The SO used to be an Exchange Administrator. I'll run this by him and see if he has any suggestions on how this can be done. Probably the solution is an Exchange solution (even though Exchange is on SQL) with some sort of SQL Server table pointing to your NAS filer for each customer to search on the files (at a guess).
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.