Mail Merge to create new spreadsheets
 

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?

Mail Merge to create new spreadsheets
 

The best place to find your information would be 'Ron's Excel Tips'
(http://www.rondebruin.nl/tips.htm)


--
Simon Lloyd

Regards,
Simon Lloyd
'www.thecodecage.com' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24472