Merging using Excel

[Rebecca]

I have an Excel workbook with 4 worksheets. I am trying to
merge four different Word letters, each with a different
worksheet. When I merge, the Word document will ony merge
with the first of the worksheets in the workbook. How do I
merge a document with any of the other four worksheets?
Say I want to merge the second letter with the second
worksheet? How do I do that?

 

[Dave Peterson]

I think I'd just move each worksheet to the leftmost position and the do the
mailmerge for that worksheet, then move the next and so on.

But here are a couple of links that you may want to read:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge/index.html

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

Beth Melton and Dave Rado have this as a FAQ at:
http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm