Freddy

Have a look at how John Walkenbach does it.

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


Gord Dibben MS Excel MVP

On Mon, 5 Nov 2007 10:39:00 -0800, Freddy
wrote:

Essentially, what I want to do is to print a pre-selected range in an Excel
spreadsheet yet insert a recipient's name (similar to a letter) into a
specific cell based on a list of contained in a range of cells within the
same spreadsheet. It's comparable to the mail merge in Word. However, I am
not using Word because Excel contains special functions that I need in the
spreadsheet. I have not written any pertinent code yet. I am using Microsoft
Visual Basic 6.3 with Microsoft Excel 2000.