Tuesday, October 31, 2023

Create mailing labels from Google Sheets for free

 
These instructions are taken from this Youtube video: 
https://www.youtube.com/watch?v=nCK7l14pLTI

You'll Need Three Things:

  1. Google sheets with names and addresses
  2. Autocrat which is an extension in google sheets
  3. Merge document template which you can find here https://docs.google.com/document/d/1-Xyf4P9ESdlP8Z6uoaFYbrlSWRvcrSInnNpoZbnC1i8/copy

Follow These Steps:

  1. Choose autocrat, then open
  2. Select new job
  3. Give the job a name and then click next
  4. Choose template from my desktop
  5. Choose select and then next
  6. Choose merge tab if you see it
  7. Choose columns (this is where you are mapping)
  8. Click next, enter a title, leave type as google doc
  9. Change the output to be single output mode
  10. Choose no to add page break between data rows
  11. Click next
  12. Leave the rest of the defaults or skip them
  13. Click save
  14. Click play
  15. When it's done, close the window
  16. Now you can preview and print the labels doc

No comments:

Post a Comment