Use Mail Merge to Create ENVELOPES in Microsoft Word Using List From Microsoft Excel

preview_player
Показать описание
Though email is certainly popular these days, we still occasionally need to send things by snail-mail. And that requires an envelope. Microsoft Word makes this easy to do, using a mail merge that pulls address information from Microsoft Excel.

In a hands-on tutorial, I’ll show you how to set up an envelope mail merge template in Microsoft Word, taking into account the envelope size and printer settings. Then we’ll grab data from Excel and merge it into a new Word document for printing.

00:00 – Starting the mail merge
00:50 – Setting up the envelope and printer settings
03:25 – Connecting to address data in Microsoft Excel
04:27 – Inserting merge fields
05:44 – Finishing the mail merge to a new document
06:39 – Sending the envelopes to the printer

Рекомендации по теме
Комментарии
Автор

What else are you wanting to learn about Word and/or Excel? Let me know in the comments below!

TinyTechnicalTutorials
Автор

I should have taken the time to learn this a couple years ago! This will help me about 7 times a year! Thanks!

hollyhill
Автор

So very helpful! Thank you for taking the time to make this video.

AdamJaenke
Автор

Tiny Technical Tutorials, I kiss your feet. Seriously. I have kind of mastered labels, but for invites to an upcoming class reunion, I really wanted to print directly to the envelopes. IMO, it just looks classier. I tried walking thru the "wizard", but just couldn't quite get it. I probably have trashed at least 50 envelopes that just looked wrong. After watching this tutorial, I recognized a couple of things that might be causing some issues, and I retried it using your excellent tips. Success!!! Thank you, thank you, thank you!!

mjturpin
Автор

Thank you so so much for this tutorial! I have a small business and want to become more efficient....and this definitely helps! Sincerely,

dangutierrez
Автор

I have been looking for this solution for am so happy

kelbyrodriguez
Автор

OMGOODNESS THANK YOU! This video was amazing and so easy to follow. I always hand write my Christmas cards and envelopes. I just wanted something easier this year for 80 cards!

angelabohman
Автор

Awesome! This tutorial is so full of helpful details. Thank you soooo much!!!

julfactora
Автор

This was a well done video. It was so easy to follow. I feel like I will be spending a lot of time watching your videos!

ConnieEadie
Автор

THANK YOU!! Your explanation was very clear and easy!

AshlynShockey
Автор

Thank you thank you thank you!!! This is the best, easiest to follow video! Precise information. Perfect! ❤

chandracarrington
Автор

Thank you for this excellent tutorial!

kathleenharrell
Автор

Thank you for the guide. For some reason the wizard wasn't working for me but I was able to do the merge with this video.

ceceliaplata
Автор

This was brilliant! Thank you so much, you've saved me a lot of hand cramping! :D

cdzoykq
Автор

Great video! Much better than a video from a guy who works at Microsoft lol

jasonbellows
Автор

So incredibly helpful! Haven't done a mail merge in a LONG time so this tutorial was exactly what I needed! Thank you! Kevin Bakewell

FBWTPA
Автор

THANK YOU!! I WAS LOSING MY MIND! ;) VERY VERY HELPFUL!

carolynalzueta
Автор

Hello .
Just beginner in Microsoft word, need guidance from where how to start.

Marwa-
Автор

easy simple guide, but also informative ✅✅.. thank you

asamirid
Автор

Wow, this is a GREAT video. You just saved my ass. You deserve something special specifically for this video alone. I just had to subscribe because I can only imagine what else you have under your belt. I cannot thank you enough. Xoxox.

humanfairy