can you mail merge in Excel

[Guest]

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 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.

 

[David McRitchie]

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.