Create Test Tickets with VBA, EXCEL, and Word Employing Mail Merge Filters

[jbaergen]

I am needing to create student test tickets to be distributed to multiple school buildings.
I have an excel document with all the data needed for the student test tickets, and I have the tickets created in a word document template (10 records per page). I can easily use mail merge to create the tickets, but I need to group the tickets by school building to be distributed as PDFs. The file name needs to be saved as follows “Building Number_School Name”. .

What I need help with is code, or some other process, to automate changing the filter based on a list of school buildings.

I'm fairly new to VBA, so please be gentle.

Thank you very much in advance!!!

jbaergen

 

[Macropod]

Is the number of records per school building constant, or variable?

 

[jbaergen]

Variable

 

[Macropod]

In that case, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB

In addition to a 'Many to One' merge, the latter handles:
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple

Although it could be done with a Word's Catalogue/Directory Mailmerge facility, using my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
Microsoft Word Catalogue/Directory Mailmerge Tutorial | Windows Secrets Lounge
or:
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
as a starting point, supplemented with VBA code for the individual file generation, you'd probably find either of the addins easier to work with.