Hey all! Brand new here. Been searching around for an answer to this but just couldn't find anything specific enough to help me. So here's what I got goin on...



Working with Windows 7 64-bit, Office 2010

I am trying to create a letter template that will be used by multiple people within our company. This letter will be in response to a request from our customers who wish to switch their billing option. In the letter's response, we will be denying their request, but will be offering a few different billing options. If the customer has a question on the these new billing options, we want them to be able to contact the correct person internally.

So since I'm creating the template, I wanted to add a drop down list. This list will contain the appropriate division's name as well as the person they will need to contact. Upon selecting the appropriate division, I would like the person's contact information to auto-populate.

So 2 questions.
1) Do I have to use legacy drop down lists to achieve this? I see there is a "run macro upon exit" option in the legacy drop down but not in the newer version. I like the newer dropdown list option as I don't have to protect the document for a user to select it. (While we want to standardize this letter, I don't want to tie the hands of those sending it out if they want to make other changes in the letter and therefore really don't want to worry about protecting it)
2) I'm a complete novice to macro writing. While I've done a lot of macro RECORDING, I've only tinkered with manually writing macro code. Just wondering how I might have the program key in the contact information (email address, phone, fax, etc.) once the drop down selection has been chosen.

Thanks in advance for the help!!