[joefox]

Hopefully someone will have an idea of how to do what I'm trying to do. We
use custom templates for MS Word 2003. The templates contain user names so
when creating a letter, we can populate the info (address, etc)
automaticatically once a name is selected. The problem is that we have to
manually edit the Names.doc file everytime we have a new user or name change,
etc. Is there any way to get the info to be pulled directly from Active
Directory so everytime a change is made in AD, it is also made in the
template file?

Thanks in advance for any replies received.

[Malin D]

Yes that is possible, with code. We create such templates for our clients.
Try asking this in the VBA/Macro group instead.

Best regards

Malin D
Office consultant/Trainer


"joefox" wrote:

Hopefully someone will have an idea of how to do what I'm trying to do. We
use custom templates for MS Word 2003. The templates contain user names so
when creating a letter, we can populate the info (address, etc)
automaticatically once a name is selected. The problem is that we have to
manually edit the Names.doc file everytime we have a new user or name change,
etc. Is there any way to get the info to be pulled directly from Active
Directory so everytime a change is made in AD, it is also made in the
template file?

Thanks in advance for any replies received.

[Malin D]

Yes that is possible, with code. We create such templates for our clients.
Try asking this in the VBA/Macro group instead.

Best regards

Malin D
Office consultant/Trainer


"joefox" wrote:

Hopefully someone will have an idea of how to do what I'm trying to do. We
use custom templates for MS Word 2003. The templates contain user names so
when creating a letter, we can populate the info (address, etc)
automaticatically once a name is selected. The problem is that we have to
manually edit the Names.doc file everytime we have a new user or name change,
etc. Is there any way to get the info to be pulled directly from Active
Directory so everytime a change is made in AD, it is also made in the
template file?

Thanks in advance for any replies received.

[joefox]

Thanks for the reply. Sorry for my ignorance, but I'm new on here. Where is
the VBA group?

"Malin D" wrote:

Yes that is possible, with code. We create such templates for our clients.
Try asking this in the VBA/Macro group instead.

Best regards

Malin D
Office consultant/Trainer


"joefox" wrote:

Hopefully someone will have an idea of how to do what I'm trying to do. We
use custom templates for MS Word 2003. The templates contain user names so
when creating a letter, we can populate the info (address, etc)
automaticatically once a name is selected. The problem is that we have to
manually edit the Names.doc file everytime we have a new user or name change,
etc. Is there any way to get the info to be pulled directly from Active
Directory so everytime a change is made in AD, it is also made in the
template file?

Thanks in advance for any replies received.

[joefox]

Thanks for the reply. Sorry for my ignorance, but I'm new on here. Where is
the VBA group?

"Malin D" wrote:

Yes that is possible, with code. We create such templates for our clients.
Try asking this in the VBA/Macro group instead.

Best regards

Malin D
Office consultant/Trainer


"joefox" wrote:

Hopefully someone will have an idea of how to do what I'm trying to do. We
use custom templates for MS Word 2003. The templates contain user names so
when creating a letter, we can populate the info (address, etc)
automaticatically once a name is selected. The problem is that we have to
manually edit the Names.doc file everytime we have a new user or name change,
etc. Is there any way to get the info to be pulled directly from Active
Directory so everytime a change is made in AD, it is also made in the
template file?

Thanks in advance for any replies received.

[Graham Mayor]

The simplest means of doing this would be to store the addresses etc in an
Outlook contacts list and set that list as an Outlook address book. You can
then call the contacts from that address book in Word using a macro to place
the data - there are examples at http://www.gmayor.com/Macrobutton.htm

An alternative would be to populate a table with your names and addresses
and create a macro to read the table and display the information in a
userform and apply the selected data to the document. For the basics, see
Word MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

I suppose that your current procedure is somewhat similar to this. Whether
it is possible to access ActiveDirectory data directly I cannot say. I have
no knowledge of its use. You could ask in a programming forum.

You appear to have joined this news server via Microsoft's web forum. To
access the vba forum look for the Word programming group.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"joefox" wrote in message
...
Hopefully someone will have an idea of how to do what I'm trying to do. We
use custom templates for MS Word 2003. The templates contain user names so
when creating a letter, we can populate the info (address, etc)
automaticatically once a name is selected. The problem is that we have to
manually edit the Names.doc file everytime we have a new user or name
change,
etc. Is there any way to get the info to be pulled directly from Active
Directory so everytime a change is made in AD, it is also made in the
template file?

Thanks in advance for any replies received.

[Graham Mayor]

The simplest means of doing this would be to store the addresses etc in an
Outlook contacts list and set that list as an Outlook address book. You can
then call the contacts from that address book in Word using a macro to place
the data - there are examples at http://www.gmayor.com/Macrobutton.htm

An alternative would be to populate a table with your names and addresses
and create a macro to read the table and display the information in a
userform and apply the selected data to the document. For the basics, see
Word MVP FAQ - Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

I suppose that your current procedure is somewhat similar to this. Whether
it is possible to access ActiveDirectory data directly I cannot say. I have
no knowledge of its use. You could ask in a programming forum.

You appear to have joined this news server via Microsoft's web forum. To
access the vba forum look for the Word programming group.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"joefox" wrote in message
...
Hopefully someone will have an idea of how to do what I'm trying to do. We
use custom templates for MS Word 2003. The templates contain user names so
when creating a letter, we can populate the info (address, etc)
automaticatically once a name is selected. The problem is that we have to
manually edit the Names.doc file everytime we have a new user or name
change,
etc. Is there any way to get the info to be pulled directly from Active
Directory so everytime a change is made in AD, it is also made in the
template file?

Thanks in advance for any replies received.