How do I do a "mail merge" from excel to excel?

J

jeanne

I want to create a merge whereby the data from one spreadsheet is distributed
to multiple sheets. The same thing as a mail merge from excel to Word, only
Excel to Excel.
 
B

Bob I

Excel doesn't do "Mail Merge", it's Word doing all the data pulling. You
will need to replicate that functionality yourself with Macro/VBA or
formulas.
 

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 (Excel to Excel) 1
Mail Merge 4
Mail Merge Formating Issues 3
mail merging in Excel 1
mail merge multiple lines in an e-mail 1
Merging data from 2 data excel sheets 2
Excel to Excel Mail Merge? 1
Why does my excel to word mail merged doc not merge last entry? 3

Top