Excel to Excel Mail Merge?

D

DP

How can I mail merge from one excel worksheet with data to another excel
worksheet containing my form?
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail merge in Excel 1
Mail Merge from excel to pdf files 2
Not getting all data with mail merge 1
How do I do a "mail merge" from excel to excel? 1
Can't edit or Refresh under mail merge recipients 1
mail merging in Excel 1
Merging Excel Cells 2
Excel data source will not merge changes to Word 2

Top