It's certainly possible to write a VBA program that will do the job. If you go that route, Pecoflyer will probably suggest that you repost this question in the Excel Programming forum. But as for using mail-merge, I've never used it in Excel and only long ago in Word; I expect it can be done but I couldn't swear to it. Let's see whether anyone has more information, and after Thanksgiving if there are no responses we can talk about how to do it in VBA, if you want to.
|