Tag: sheets

Boot-up
These were the suggestions from last time that you came up with …
Password Manager [Aelfryn] Creating and updating a website [Martin] Google settings [Paul] Facebook settings [Me ???] Windows settings [Don] Backups (and archiving) [Stella] Labels (next session) [David] Photos – organisation and folders (finding) and editing [Toni] Video-editing [Toni] Building an internet browsing computer using Linux from an old laptop [David – Digital Projects maybe] Have I forgotten any? Send me any further suggestions.
Charging your phone overnight
News
Not much …
Facebook execs deny knowing anything!
YouTube video-streaming in Europe may be curtailed due to EU Copyright legislation.
Google runs into “problems” with use of health data.
Black Friday, Voucher Codes, etc. etc.
… anything else???
Labels
You need a printer! If you’re using an iPad/iPhone – you need a printer that supports AirPrint.
Sorry … nothing I could try out for Android tablets, or phones – does anyone want to research this?
Finding a solution that works on every machine is challenging. Using Google suite the best bet – Contacts, Sheets and Docs with an add-on from Avery.
Start with Contacts. If you don’t use gmail for contacts, go to the Contacts in your eMail application – you need to Export chosen Contacts as a .csv file.
So for Google (gmail) – go to contacts.google.com …

You also need to add the Avery Label “add-on” to Google Docs
– docs.google.com
 

Then in Google Sheets (sheets.google.com), you Import the .csv file

Back to Google Docs and choose new merge from Avery Label Merge Add-on …

Select the Avery Product Code – L7160 – 21 labels is a pretty good starting point …

… and then the .csv file you want to merge …

Select the fields that you want to print from the panel on the right-hand side of the Google Docs screen …

… and then Merge at the bottom of the Panel. A message should appear telling you that a new document Avery_L7160 has been created, and it should look something like this …

… which you should then be able to print – once you’ve loaded the Label Printer Paper!
Also a demo of using Label Printer for iPad/iPhone.
Here’s a good summary of how to do it in Word, Pages (Mac) and Google Docs