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. Also P.S. my printer messed up a couple of times and I had to re-print some of the words by deleting the messed up prints. Sorting/aligning words and definitions and printing again.
Open a new spreadsheet and on sheet 1 place two columns with headers “front” and “back”
Now fill in the corresponding information for front on column 1 and back on column 1
2) Preparing the word document
File> New blank document
Layout>Page Setup>bottom right corner
Change margins to 0.5″
change to landscape
Change Page Vertical alignment to Center
3) Import/Auto-fill with Excel words
Mailings Tab> star mail merge >Start Mail Merge> Step by step mail merge wizard step 1 Select Document –> Letters step 2 Select Starting document –> use current document step 3 Select recipients –> use and existing list and browse for excel sheet (with header in sheet one with one column) step 4 Write your letter –> click on…more items and select column header and press insert step 4b –> Now format the text size( ~100) and set align horizontally step 5 Preview your letters –> Nothing really to change, click next step 6 complete merge –> Click on “Edit Individual Letters” Merge records, select ALL * Now fix any of the cards where the text is overflowing into the next card. Highlight and change text size to something smaller.
4) Print front of cards
Now you should be able to print these cards in the order they appear in the excel column
Note: Also there seems to be a error in the last card with it not being centered. Print a blank card at the end of the list.
5) Back Side
Repeat with Column 2 inserting “back” instead of “Front”
Generate another set of pages with the back text on all the cards. Font size should be about 30 depending on the index card size and amount of text.
Make a note of how your printer is printing relative to how you load the index cards into the paper feed
Load the cards in order of how you previously printed the words or the definitions won’t match up
Repeat this guide to create a set of cards with the definitions based on the excel sheet.
I recently bought a WII from a garage sale for cheap and wanted to hack it and backup the games I bought to speed up the load time. Below are the steps I followed and useful links i used to set everything up!! Wii should be in 4.3U system version
I bought a broken Wii from a garage sale for cheap, included everything and 4 controllers, score! I decided to try and fix it and maybe play it in the future. I really like mario kart 64 and I hear the Wii version is very similar 🙂
The following lines of code will help you turn off the power and activity lights from your Raspbery pi 3 B+. Note: this code worked with one of my raspberry pi’s and not on the other. I still need to see why.
I’m not great at parallel parking, and telling the dimensions of my car. After watching my brother effortlessly parallel park with his backup camera, I decided I needed one on my car. Unfortunately my car is an old 2007 Honda Accord that doesn’t have a camera by default, and a custom installed camera will be expensive. I decided to do some research on a backup camera and finally install one myself.
Camera: Generic Camera and Display by seller DoHonestBest