![]() ![]() Clear the first Print Area before setting a new one.īe sure to test your settings by specifying a small selection of pages (say pages 1 to 3) to print out in the main section of the Print dialog. Then you'll need to load those pages back into the printer, and use Print Area to print the back side pages. You can select the columns holding the fronts of your flash cards and choose "Set Print Area" from the "File." menu. If your printer doesn't support two-sided printing, there are still options. Here you also select the order in which the pages print. In the "Layout" section of the Print dialog, you can choose "two-sided" printing if your printer supports that (mine doesn't, so the choice is greyed out).If not, you can format the cells holding your text and repeat this step until you get the desired result. Make sure your text appears correctly within the page boundaries. The page boundaries will appear as dashed blue lines. Depending on your version of Excel, the dialog should look similar to this:Ĭlick "OK", and return to your spreadsheet. ![]() First, use the Page Setup dialog to specify A4 paper and choose portrait or landscape mode.Let me know if you need more help with this approach. Then sort by column E and do the mail merge for the back of the paper. Now you can sort by column D and do the mail merge for the front of the paper. The Word template is available, but only has the outside borders and flipping text for the back side is difficult. Copy the formula results and use paste special > values to paste the values over the formulas. We recommend using our free Design & Print Online software which will show the safety area and make it easier to design the back of the card. With hundreds of values you only need to type E2 and E3, then in E4 use a formula =E2+2 and copy down. When the paper is flipped over, you need a different print order to ensure that word "a" matches the details "aa".Ĭreate a helper column with the order in column E. This is possible if you keep your wits about you and add some helper columns to sort the data.Īssuming the mail merge fills the cells from left to right then down, the words will end up on the cards like shown in the table sketch "print order on cards". You need to change the order so the first card gets the correct values printed on its back when the paper is flipped. Now, the tricky bit is the order of the records from Excel. Merge and printĬreate another mail merge with the same table and put the the other fields into the cells. Now find a printer that can print double sided and print the document.Įdit: With 10 cards per page, use this approach:Ĭreate a mail merge with the suitable table for your paper and put just the keyword into the table cell. This way you end up with a multi-page Word document that should have pages with a word followed by pages with the details. Run the merge and let it merge into a document. Put the Word field on the first page, format as desired, then insert a page break, so everything else goes to page 2.Īrrange the other merge fields on page 2. Connect to the Excel workbook as the data source, then build the merge document. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |