I have read various postings on using VBA to create a Excel to Excel Mail
Merge. However I'm not sure how to accomplish something slightly different.

I have a spreadsheet I would like to send out to our clients for use. I
have a second spreadsheet that contains name & address information. I would
like to mail merge this data into my existing spreadsheet, but have it create
a new excel file that I could then e-mail to the clients.

I have seen code to mail merge in excel and then print, but can a merge be
used to create new spreadsheets?