Generic Template to custom document.

V

VinceV

I'm looking for ideas to cerate common Word templates for memos, letters,
etc. and have the user information inserted automatically when the template
is chosen. My goal is to have a common set of templates on a network share
so that changes are easy to implement.

Items like Name, E-mail Address, Telephone Number, Addresses, etc are all
available from the Exchange global address book but I've been unable to find
a VBA example that shows how to access that information for the current
user.

I'm considering other options like creating a registry key/values with a
user form to maintain the info.

Has anyone already solved this problem? Could you please share the
solution?
Can you point me to a web site that can get me started?

I can write the code (and will happily share it) if I can just get pointed
in the right direction.

VinceV
 
M

martinique

It's easy to automate Outlook from VBA: much easier to use its storage and
editing functions rather than write your own. With the added advantage that
you can use the same basic method for retrieving data whether you want to
user's details (for inserting in the letterhead or whatever) or the client's
details for inserting in the body of the document.

However my experience with this sort of project is that it's a bit an
elephant behind the door: it looks small and simple to start with (all you
see is the tip of the trunk) but the further you go, the bigger it all gets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top