So here's the deal. I work for a state run mental health facility, so they are very careful about doing anything outside of what the program, in it's original form, can do. What I want to be able to do is create a spreadsheet in excel 2010 which gives me my due dates for various paperwork entries I have to complete. That much is easy enough, what would be great is if it automagically could either notify me in outlook when these are due, or even better email me. Then I would place those emails in an archive folder which creates my to do list.

I'm not sure how to go about the excel to outlook parts of this. Additionally, what I'd absolutely love is if I could somehow get certain due dates in the excel spreadsheet to export client names to a templated word doc to send out to my clients. Meaning I'd save myself a ton of time, and only have to hit print when a certain amount of time has lapsed.

Clear as mud?

Help if you can, I'm hoping to get this all figured out sometime soon.

thanks