Excel to Excel Mail Merge?

  • Thread starter Thread starter DP
  • Start date Start date
D

DP

How can I mail merge from one excel worksheet with data to another excel
worksheet containing my form?
 
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
 
Back
Top