Not sure this is the correct topic area so I apologize in advance if so. Trying to score points with wife!
My wifes Accounting Department has been given the tedious task to send a form letter to specific Departments at the University. It may or may not be the same Departments each time. They currently have the list and form letter in Excel. I found a few Excel help topics but couldn't seem to make the formulas work.
So, Is there a "simple" way in Excel to create the list, say on page 1, then select the appropriate Department from a pull down box on Page 2?
I guess the dream would be to create something, say in Access, that they could simply check each Department that requires a form letter and it prints out the required form letter.
Can anyone help?