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
 

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 from excel to pdf files 2
Mail merge in Excel 1
Merging worksheet into MS Word mail merge 6
Not getting all data with mail merge 1
mail merging in Excel 1
Merging Excel Cells 2
How do I do a "mail merge" from excel to excel? 1
Excel 2007 - combining worksheets to use for a mail merge 1

Back
Top