A start could be having a look here at John Walkenbach's site.

http://www.j-walk.com/ss/excel/tips/tip92.htm

Downloadable workbook with code for mailmerge using Excel only.


Gord Dibben MS Excel MVP


On Wed, 7 Mar 2007 07:17:16 -0800, gloria81101
wrote:

I have created a certificate in Excel (which would be under sheet 1) and have
all the names listed in sheet 2 that I need a certificate for. How do I
create a formula or macro that will insert each individual name automatically
when I print?