It sounds like you only need one drop down box and the other three can then be plain text CCs filled from some information source. The trick is deciding where to store the company name, address and phone number.
Do you have a table that lists the relevant information somewhere:
Manager; Company; Address; Phone
A non-coded method would be to store each of the variable information blocks in a particular building block Gallery and Category and then use a Building Block content control to allow the user to select one to insert all at once. This is actually pretty easy to set up and far easier than trying to solve it with a macro.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|