Merge 2 Worksheets like Word Mail Merge???

Hi~ Is it possible to merge 2 Excel worksheets, similarly
to Word Mail Merges? Where could I find info on this?
THANK YOU!!! ~Lori

Both my Data Source and my Main Document (a form with) are
Excel worksheets.

I was able to copy the Main Document to Word, and do a
merge that way, but now in Word I can't change the
spacing, column widths, etc. In general, I am way more
familiar with Excel. Thanks again!

Hi Lori,
Mail Merge does not merge two Excel documents. It can only
pick up one Excel worksheet and it must be the first worksheet
in your workbook (by tab arrangement).
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

The above is specifically for printing labels so one would not
mess with margins. But for printing letters which would be very
similar you would have a lot more control over margins and things
than in Excel. You just have to get familiar with the toolbar
menus in Word.

So maybe you should describe what you want to do in Excel and
what you want to do in the way of printing using MS Word.

You might take a look at
http://www.mvps.org/dmcritchie/excel/vlookup.htm
to fill in some missing information found on another document,
VLOOKUP is strictly an Excel table lookup.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lori Factor-Marcus" wrote in message ...
Hi~ Is it possible to merge 2 Excel worksheets, similarly
to Word Mail Merges? Where could I find info on this?
THANK YOU!!! ~Lori

Both my Data Source and my Main Document (a form with) are
Excel worksheets.

I was able to copy the Main Document to Word, and do a
merge that way, but now in Word I can't change the
spacing, column widths, etc. In general, I am way more
familiar with Excel. Thanks again!