How to Clean Up Address Lists for Data Merge

As a stationery designer, printing envelopes for clients is a great service to offer. But a lot of times an address list you receive needs A LOT of work before it's ready for data merge... and while you can simply send it back to them with your requested changes, sometimes it's better to just quickly do it yourself! This video shows you how I edit address lists in Google Sheets. Not familiar with Data Merge? Watch this video: https://youtu.be/sDsG-oaL_zE Prefer to Data Merge in Illustrator? Watch this video: https://youtu.be/VTc8iR8t8t8 Get the Adobe Suite https://prf.hn/l/xElJ8Gj Sockeye Font by Design by Laney (shown in the envelope doc) https://www.etsy.com/listing/1856959557/sockeye-handwritten-font-wedding ~ Links contained in the video and/or description may be affiliate links which earn us a small commission at no cost to you! We appreciate your use of our links so we can continue making free content for you! ---------- Hi, hey, hello! Welcome to the Design by Laney channel! I am a wedding invitation designer & stationery business educator! On this channel, you'll find videos featuring design tutorials, systems reviews, and the most requested tips and tricks for running a creative business - yes, including my favorite printers! 📬 Sign up for our Email List for more tips and tricks! https://designbylaney.com/email-list 💌 New to Invitation Design? Check out our beginner *From Start to Suite* course! https://designbylaney.com/from-start-to-suite 🤓 Sign up for our FREE Adobe Illustrator course series: https://designbylaney.com/free-illustrator-course 👩🏻‍🏫 Want to learn even more about running a stationery business? Join us in Stationery School! https://designbylaney.com/stationery-school 💛 Follow Along: www.instagram.com/designbylaney www.designbylaney.com www.facebook.com/designbylaney www.pinterest.com/bylaney 🖨️ My Favorite Print Shop www.printswell.com/a/laney 📋 Try Dubsado https://www.dubsado.com/?c=designbylaney 📋 Try Honeybook http://share.honeybook.com/laney