Hi all I have a workbook with a sheet that I have made into a form. On another sheet I have a list of names that is placed into ABC order by another macro. so they are displayed down a column like this:


Apple, John
Butter, John
Charlie, John

etc.

I want to assign a button to create a mail merge like situation except I want to keep it in Excel and make it print that form out for each of the members listed.

I have found some info on this online but I cant find a solution for my exact situation. I know I need to use a count function to determine the number of pages to print, and I would like the button to open a print preview first.

Thanks!