Hi,

I am trying to create a letter template that gives the user an option to select their business division and branch from drop down boxes which will, in turn, pull the address and contact details into the footer of the document so that it can be used by any user in the company regardless of division or location (the company has five divisions and each division has up to fifteen branches).

Ideally the contact details would come from a spread sheet so that the information is updated easily by an administrator without advanced office experience.

Is this at all possible or am I asking a bit much?

Any and all assistance is greatly appreciated.