Font size should be about 30 depending on the index card size and amount of text. Generate another set of pages with the back text on all the cards.Repeat with Column 2 inserting “back” instead of “Front”.Print a blank card at the end of the list. Note: Also there seems to be a error in the last card with it not being centered.Now you should be able to print these cards in the order they appear in the excel column.Highlight and change text size to something smaller. * Now fix any of the cards where the text is overflowing into the next card. Step 6 complete merge –> Click on “Edit Individual Letters” Merge records, select ALL Step 5 Preview your letters –> Nothing really to change, click next Step 4b –> Now format the text size( ~100) and set align horizontally Step 4 Write your letter –> click on…more items and select column header and press insert
Step 3 Select recipients –> use and existing list and browse for excel sheet (with header in sheet one with one column) Step 2 Select Starting document –> use current document Mailings Tab> star mail merge >Start Mail Merge> Step by step mail merge wizard Format the text to fit the size of the index card.Change Page Vertical alignment to Center.Now fill in the corresponding information for front on column 1 and back on column 1.Open a new spreadsheet and on sheet 1 place two columns with headers “ front” and “ back”.Sorting/aligning words and definitions and printing again.Ĭenter text vertically: 1) Preparing the excel spreadsheet my printer messed up a couple of times and I had to re-print some of the words by deleting the messed up prints. I’ve been trying to figure out how to do this for a while and now that I finally figured it I thought I’d document it 🙂 Hope someone finds this useful! Also a great way to print out cards for board games on both sides This may seem like a very tedious process but it’s nice when you are printing 100-200 cards.
0 kommentar(er)
