use excel database to populate 2 different word doc

[RoadDog83]

so im wondering if it is possible to have an excel data base that i use to automaticallay populate a word doc.

i have 2 different word docs that have userforms pop up when the doc is opened. i want to be able to select a persons name or whatever from a drop down list that is my database and have all of the info automatically filled out in the userform.

is this possible? does anyone have an example doc they could show me?

[macropod]

Hi RoadDog83,

This sounds like a candidate for using Word's mailmerge functions. A Word mailmerge can produce an output for a single record or a group of records matching user-defined criteria. No userform required, though you could have the userform set the mailmerge filtering criteria, plus populate the document with whatever else you're inputting via the userform.