Excel Mail Merge macro

[jtsou]

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!

[dflak]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.