Hi,
I'm trying to automate a procedure where a document based on a specific
template, asks for a value from a specific field in a database so that only
that record will be merged into the document based on that template. I'm
using Office 2003 but would prefer it to work in Office 2002 as well.

Basically, the spreadsheet is the data for a mailmerge document and I'm
using the InputBox function to retrieve the record that matches the search
string (which can only be a 5-digit number) from the "IDCode" field in
"Database.xls" in the "C:\Database" folder. I have a number of other fields
within the template that are populated from the database.

TIA,

Pete