pulling fields from a database

Question

I need to pull fields from a database into a Word document on specific cases identified by a case identifier.  I'm familiar with mail merge, but need to only draw from one case at a time.  Can anyone tell me where to start?

Thanks in advance.

Answer 1

Mail Merge will do this as well. Simply choose only the record (recipient) for the case identifier you want. You can use the choose recipient button.

• Mail Merge
• Mail merge using an Excel spreadsheet - Word

(Doug knows the ins and outs of mail merge better than I; however, I've been using mail merge to produce documents for a single record for years.)

Answer 2

Look at the links that I gave you!

Answer 3

Thank you so much for your reply Charles.

The thing I am looking for is how to select only 1 unique record from the recipient list.  My recipient list has over 5000 items.  I was hoping to get a prompt or write a macro or some other type of tool inside the mail merge to just enter in the unique identifier instead of scrolling through all 5000 items.  Do you know if mail merge has such a tool?

Answer 4

See the following pages of Greg Maxey's website :

http://gregmaxey.mvps.org/Create\_and\_employ\_a\_UserForm.htm

http://gregmaxey.mvps.org/Populate\_UserForm\_ListBox.htm