For each of the fields on your form, use a VLOOKUP or INDEX formula to extract data from your
database. Key the formulas to either a value (for teh VLOOKUP) or step through the indices when
using the INDEX form, by putting the keyvalue or index into a cell referenced in the formula.

HTH,
Bernie
MS Excel MVP


"DP" wrote in message
...
How can I mail merge from one excel worksheet with data to another excel
worksheet containing my form?