can you mail merge in Excel
 

I have created an enrollment form in Excel (master file) and would like to
merge it with data from a different worksheet and then print all of the
merged files simultaneously, just like you would in Word. I did not create
in Word because some fields require complex calculations.

I am not up on macros, so if there is a way to do this w/o macros, even
better.

Excel doesn't have a merge feature. Perhaps you could do the merge in
Word, using the calculations from Excel.

Otherwise, you would need programming, to loop through the records you
want to print.

Ft. Worth user wrote:
I have created an enrollment form in Excel (master file) and would like to
merge it with data from a different worksheet and then print all of the
merged files simultaneously, just like you would in Word. I did not create
in Word because some fields require complex calculations.

I am not up on macros, so if there is a way to do this w/o macros, even
better.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Ft.,
You might take a look at
Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
If not for labels you might want to also look at some of the
references.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Debra Dalgleish" wrote ...
Excel doesn't have a merge feature. Perhaps you could do the merge in
Word, using the calculations from Excel.

Ft. Worth user wrote:
I have created an enrollment form in Excel (master file) and would like to
merge it with data from a different worksheet and then print all of the
merged files simultaneously, just like you would in Word.
complex formulas blah blah blah....