Macro for import from AD?

[Jonathan]

Hello,

We have the following situation;

There are +/- 60 locations in our company, each of which have 2-3
departments.

Management wants all users to use a standardized template for letters.

However, they want to display the address and department on the
template, which of course is different in 60x2 ways...

One solution is just making 120+ templates, but thats not much of an
option cause if just one tiny thing changes, you would have to change
it 120 times.

I was therefore wondering whether it would at all be possible to
create a macro that on starting a template, would get all the required
info from AD (address, department etc) and place them into predefined
fields in the template that was opened by the user.

Does anyone know if this is at all possible?
Or does anyone have any other possible solutions to this problem?

Thanks,

Jonathan

 

[Howard Kaikow]

Yes that is possible and is a good reason to learn how to create macros.
You could do this by using a combination of AutoNew, AutoOpen and Auto Close
macros in the template.

To learn more about writing macros, start wit books in the Word VBA book
list at my URL below.