How to Create Mailing Labels in Word using Data from Excel

preview_player
Показать описание
In this video, I will show you how to create mailing address labels using an Excel worksheet. If you maintain the addresses in a spreadsheet, it is super easy to merge this list into mail label in Word. This is a great Excel and Word time saving tip.

WATCH ME NEXT
✅️ Stop using VLOOKUP in Excel there is an EASIER way...

✅️ How to EASILY convert a Word document into PowerPoint slides

✅️ How to embed an Excel file into Word

🚨 MASTERCLASSES
👉 Master the Basics of Microsoft Excel

👉 Master Projects in Microsoft Teams

🏃‍♂️ DON'T GET LEFT BEHIND

📧 LET'S CONNECT

☕️ FUELLED BY COFFEE

Disclaimer: Some of the links in this description are affiliate links, where I earn a small commission on any of your purchases at no additional cost to you. This helps to support the content I provide on the Ready Steady Excel Channel. Thank you for your support.
#ReadySteadyExcel
Рекомендации по теме
Комментарии
Автор

The labeles would have looked better if you centered the data before printing. How can you do that? Also, if I want to print only a few labeles and the Avery paper has only a few clear labels let's say 10 instead of 30. How do I set things up for such a scenario?

dking
Автор

How do you not print a blank line in address labels. Some of my addresses have address 1 and Address 2. Other don't have address 2.

diannerhodenbaugh