Eggyhead

Thank you so much! This is so clever!

I’m trying to make 6 decks of 30 cards for a classroom activity, and unfortunately A4 is the only print size available to me. In order avoid having 6 massive cards per sheet and waste 30 sheets of paper, I’d like to have 18 smaller cards (3 different cards x6) per sheet, 10 pages total. In other words, I’d like to set up the data merge to repeat each field from the data source 6 times before incrementing to the next field. Is this possible? The only way I’ve managed to make this work is to make the data source include 6 duplicates of every card. This is manageable, but I’d much rather have a single entry for every card variant in the data set just to make editing and adding new cards a breeze. Attached below: Data Merge Example.afpub is my pre-merged document setup. Data Merge Example Source.xlsx is an example of the kind of data source I'd like to use for the afpub document. Data Merge Complete.afpub is how I would like the data merge to result. Honestly, I'll be surprised if there is actually a way to do this. Many thanks if anyone has an answer for this. Data Merge Example.afpub Data Merge Example Source.xlsx Data Merge Complete.afpub

+1. I am a teacher and I am just starting to use Publisher to design handouts, prints, and plans for lessons. (Have been using Photo for the past year, but I hear publisher might be better for the kind of materials I make.) I would like to be able to name one page, for example, "Lesson 3 - Print A," the next "Lesson 3 - Print B," and the next after that "Lesson 3 - Card Set," and so on. Next, if possible, I'd like to be able to export them all into individual png files (I can already do this) but with their names intact.