![]() Next to each of the fields that we had generated in the spreadsheet should be a little pencil icon (you’ll have to hover your mouse of the field to see the editing icons). In the new window that pops up, Give the form a title and fill out the description so that your friends and family know what the form is for. Go to “Tools” in the spreadsheet’s menu and choose “Create a form”. In the first row of the spreadsheet, put the following titles in individual cells from left to right: “Name” “Last Name” “Street Address” “City” “Postal Code”. In there, click on the “Create” button and choose “Spreadsheet”. Once you log into Gmail, at the top of the Gmail interface click on the link to “Drive”. If you don’t have one, then go get one now. ![]() Use the CSV file with Avery Design & Print Online to perform a mail merge and print mailing labelsįirst off, you need a Gmail/Google account. Download the populated spreadsheet as a CSV file Generate a form that you share on Facebook, Twitter, email, etc. Create a spreadsheet with headers for each element of the address (Name, Address, City, etc.) I didn’t want to go and contact every single friend/family member to ask them for their current address, so I decided to put the power of Google Docs to work for me. This morning I was trying to put together my mailing list for my family’s holiday cards.
0 Comments
Leave a Reply. |