Word fetching data from Global Address List in Outlook

[Sina Bahrami]

Hi,

I am a reasonably experienced JavaScript / Flash ActionScript programmer,
but this is my first venture into the world of Visual Basic. I have been
given the task of creating a Word template that when opened, queries the
user the following information:

Who is the document written by? (One writer may have many people he writes
for)

Who is the document for?

And a few fields that are unique to each document. Now, ideally, the two
fields listed above will link up to data in the Outlook Global Address List
and fetch other details, like address and phone number, related to the names
given above. I imagine that when having queried the user for the fields, it
populates certain parts of the letter with the data.

The key is that everything that can be predetermined is done when the user
opens the template and that it is as quick/easy as possible and that all the
data is linked up with data from Outlook.

I am looking for a starting point or an overview of what I need to do to
make this happen. Perhaps maybe there are already templates like this ready
to be customised? Again, this is the first time I am doing this, so any help
would be appreciated.



sina

london

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

You need to use a userform and have the Initialize event of the form load a
combobox on the form with data from Outlook

See the article “How to create a Userform” at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

For the Outlook bit, see http://www.slipstick.com/dev/code/popcombobox.htm



--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP