Userform for mail merge (Excel): single record, multiple documents
Hi uber geniuses!
I've got a couple of queries, but I've separated them across different threads - I hope that's ok! I thought it would make it easier.
For this one, I need to be able to have the user enter in a row number from the Excel spreadsheet, and then have them select which documents they need to create for that record. I then need each document to open in a separate window (ie, not merged into the one document as Word usually does).
I have set up the basic userform with a button (frmMerge), but Iím not sure where to go from here Ė at a complete loss unlike the other userform, where I at least have something! Is this even possible? Iíve tried looking through the earlier posts here, and there seem to be some that might be similar, but Iím such a beginner that Iím not sure what Iím looking at. Sorry!
I've attached my test database and two test documents with some example merge fields so you can see what I mean. I know my coding is horrible - forgive me, I'm a beginner!