ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
How to Mail Merge Address Labels - Office 365
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2019
- Learn how to Mail Merge to create address labels using Microsoft Word and Excel. Quickly take a spreadsheet with contacts and create an address label sheet with ease. No need to paste individual names and addresses into an address label sheet.
Mail Merge allows you to send customized envelopes, letters, and emails. Mail Merge leverages Microsoft Word and Excel.
Don't have Microsoft Office? Mail Merge for free using WPS Office: • How to Mail Merge in W...
As full disclosure, I work at Microsoft.
Excellent presentation. Very clear, economical with words, straight to the point. One of the best tutorials I've seen. Thanks
Every Christmas I create labels for Christmas cards and every year I am on TH-cam getting a refresher. Great simplistic presentation. Thank you.
This was a great tutorial!!! Thank you for not over talking and being clear and efficient with your communication.
I had not done a mail merge in years and could not remember how to do one. I found this video and I was able to follow along and get it done. Thank you for posting this. You made the whole process simple. I will be looking up your channel when I need more Office help.
This was so great. I needed to try to figure out exactly what you were talking about, and I've been researching for hours. So Simple and easy to follow you. Thank you so much.
Great tutorial! Everything was explained perfectly and was easy to follow. I'm processing a 1,000 letter project today and am being sent the addresses in Excel. Thank you so much for taking the time to do this video!
VERY WELL DONE!-I HAVE USED THIS VIDEO SEVERAL TIMES OVER THE PAST THREE YEARS TO DO LABELS. THANKS JOHN
Kevin I know you made this video some time back, but it recently came in very handy for helping me create mail labels for a wedding and the invitations. I much prefer using Excel for creating data for obvious reasons and this worked great.
I was in a panic and your video was just what I needed. Very clear explanation and I was successful in creating labels for our organization. THANK YOU!
My wife was in a pinch with printing labels for Holiday cards and this video saved so much time for us. Thank you!
Thanks for the refresher, I haven't done this in thirteen years, I used to use mail merge daily.
THANK YOU!! I followed you step by step, and was finally able to print out my address labels. You were very clear in your instructions.
You just saved my non-profit group so much money as now I know how to mail merge for our mailings! TY!! Clear, concise, and helpful teaching and presentation.
Great video and easy to follow. Created labels so much faster than I was doing by copy and pasting to label template. Thank you very much!
Hi Kevin, This was way more helpful than the other 3 videos I watched. I used to used this years ago but you snooze you lose. I am always soooo grateful for your videos. The other day I was trying to learn about SEO and I was thinking "where the Heck is Kevin????" Anyway, you are awesome and helping this 50 year old stay in the game!
Thank you. I tried mail merge four times, then followed your tutorial step by step and it worked the first time.
For instructional videos you are definitely at the top of your profession. You have a KISS approach but with the sophistication to raise the bar when necessary. Your pacing is spot on. As a starting point for Windows related tasks, and many others, you should be the first stop..
Thank you ever so much for the fully detailed procedure. I have worked all day trying to get the mailing labels to convert to labels. I was using the help from the software and there was just one step that it did not include. Now that I know the steps....mission accomplished.
This was extremely helpful!!! Not overwhelming and quick to the point. Thank you so much for posting!!!
Have you tried using these instructions for merging postcards? I cant seem to get mine to work.
By far THE BEST VIDEO ever on mail merge. Thank you for the wonderful and easy to understand presentation!!!!!
This is EXACTLY what I was looking for and with a clear and easy to understand explanation! Thank you!!
I agree wholeheartedly!
Came back for more. This time I typed a step-by-step instruction from you video. I'm glad it was still up. Thanks again.
Ok so I tried it, but Word only spits out the first 30 labels? How do I get ther rest of them on the word document?
Great video! I struggle printing Christmas card labels every year, and this makes it simple. Thank you!
I wanted to thank you for the very useful tutorial. I do need to point one thing out, however. None of your labels for New Jersey will get to their location. Mail Merge dropped the 0 at the beginning of the zip code. I had hoped you addressed this issue in your video, but apparently you did not notice it.
Thank you for this!! I really appreciate it! Our church will be sending out its first Newsletter in over 2 years thanks to your help!
Terrific tutorial. I jumped right in, followed your steps and Voila! A perfect merge, ready for printing. Thank you!!!
Thank you so much for this video. It's been years since I had to do a mail merge. LIFE SAVER!!!
Thank you for this lesson. Simple, clear and easy to follow for my project.
Wow! So helpful! Your step by step saved me hours of trying to figure this out or retype into word. THANK YOU!
Thank you for saving my job! I might be able to slide through for a few more weeks. LOL
Thank you kev! Thanks to this video my wife and children have been released from ransom!!
Well done.....forwarded to a friend who was struggling with creating mailing labels.....THANKS
Very helpful Kevin! Thank you so much!
Super helpful, helping someone at work make labels for holiday cards. Thank you
Excellent THANK YOU!! I followed you step by step, and was finally able to print out my address labels.
You were very clear in your instructions.
Outstanding! I've been working on this for several days on my own reading Word. Thank you for putting this video together!!😀😀.
You're a life saver and thank God MS doesn't change much over the years.
Thank you! I was stuck on a step and couldn't figure out why my merge wasn't working. This helped a lot!
I notice that your labels have an added space before the name on the top line, just like mine had. I "fixed" mine by adding a space before subsequent lines in my Excel document so at least they'd all line up on my labels. Do you have a better fix for that?
Excellent I was able to make my labels with ease with Kevin’s step by step. Thanks.
Glad it helped!
Thank you so much. This looks so easy. I need to do this for wedding labels
Awesome...I've been pulling my hair out trying to figure this out! Thank you
This is amazing. You saved me hours of copy-pasting labels
You just helped me in my assignment, thank you very much! This video helped me a lot.
Thank you so much. I used to do MM docs all the time, I couldn't figure out why I was getting just one label autofilled and not the others, thank you for pointing out that I needed to "update all labels". Thanks again.
Good Video. Here is my problem with envelopes or labels. The US Post Office likes addresses to be single-spaced. If you look closely at your resulting labels they are double spaced. The OCR at the post office has difficulty with the blank lines. Second, my Access table/query has fields that are blank like a second person's name that needs to be included in the address or an additional address line like Add2. When you conform to the US post office address guidelines by putting a soft return (shift + enter), the merged label or envelope includes blank lines for missing data. In other words, it doesn't suppress blank lines when no data is present in a particular field. How do you suppress lines in a merged label, envelope, or letter when not all the records have data for all fields?
I have the same issue too regarding double spacing.
This is a good demonstration video. I haven't done a mail merge yet but hope to do so with the help of this video.
The tutorial was great but WHY do the labels come up double spaced?? I have changed everything I can find to single spacing but it still prints double spaced. Some of my addresses are 4 lines.
This enabled me to get my Christmas card list printed once again! Thank God for TH-cam, and I mean that literally.
Thanks. I use this for Christmas card labels once a year and never remember how I did it. Don't go away...ever.
Well done. Took all of the uncertainty out of making label mail merge.
You made it so easy for us, thank you veery much!
Thank you!!! You made it so easy.
This was a big help! Thank you, Kevin!!!
Thank you for your clear and straight forward instructions.
Kevin, super tutorial! I used your teaching on this Sunday morning to make a mailing list for my scouting group. This is very helpful!
Thank so much for this tutorial. It was very helpful.
You didn't say what you did at Microsoft, LOL. Great video. Clear and concise information. The length was great. Thank you.
Thank you that was so helpful to follow up with you!
Would be nice to do THIS in Mac Office 365. There is no wizard. No address block. Manually have to add fields manually. Took me all day to figure out how to do this. Your video helped with update and a few others, but a lot of differences on the Mac.
Thank you. I don't make labels often so every time is like a first time! This was clear and I followed you step by step, stopping the video and doing the same step in Word. I am looking forward to Windows 11 which should require less back and forth!
Thanks again, I would have spent all day trying to figure this out.
This is the best tutorial! Saved me hours at my job !!
Anybody else having problems with getting the labels to align so they print on the label sheet correctly??
Yes! Exactly! Please if you found the solution, share it with me 🙏 thanks!
Yes! Having trouble figuring out how to center the text on the label(s).
So my labels set up good but the only issue which is a big one they are printer too high and it cuts off the contacts name. How can I move it down so I don’t waste more labels. Note I’m using Avery 5263 labels. Any suggestions?
You have to make sure you select the correct configuration for the type of labels you have. Then click on address block and click around and choose the best layout make sure to click on preview labels to see how it aligns (make sure you click “Update all labels so it can affect the rest of your list”
Space it down one line if needed.
First print on a sample paper and see if it lines up with the labels.
Thank you! This is exactly what I was looking for.
Thank you so much for this! Super helpful.
Wow so far the best one I can understand. Thank you
Great presentation. I would like to know more about Pivot tables. Thanks
Loved your clearness in explaining and I was truly satisfied.
You should also check your settings. If the "Confirm File Format" box is checked under "options, advanced' general"
Thank you so much I was at work trying to figure this out for an hour 🤦🏻♀️
I would correct the ZIP codes that begin with a "0" by changing to text for the zip code block in your spreadsheet.
Thanks ,excellent tutorial for making personal mailings look professional.
Thanks brother! You really saved me ALOT of time and frustration!
So pleased I found this. Thanks from the UK
Thank you! Perfect presentation.
Thank you. That was easy way better than trying to copy and paste all those addresses.
thanks for the precise instructions.
You were so helpful & thorough. Even though I had a different version of Word, I was still able to get it done!!! Thanks so much!
Good tutorial brief and to the point. thanks for the refresher.
Thank you for being awesome enough to post this. So helpful!
I forgot how to do it and this video made it so simple. Thanks
Wish I had your knowledge of computers, another helpful video, thanks 👍🏼
had to do this for my computer science class great vid thx!!!
Thank you so much very clear video. I'm going to try now.
I learn so much from you. Thank you so much!
This was so helpful, it saved me so much time!! THANK YOU!!
still a great source for information. Thanks
Hi Kevin - After 3.5 hours, I finally found this TH-cam video and figured out how to do a mail merge. Thank you. I noticed in your example that the "Name" line had a single space indentation and I was hoping you would speak to that. My semi-final product had the same, so I went into each label and removed that single space. However, the final product pdf put that space back in. What/why is that happening and what can I do to remove that single space?
so helpful, I found the answer to my question in your tuto - how to print all in one go ;) merci Kev !
Very clear video, thank you.
Thank you for this video. I'm trying to create labels that are the same for the entire sheet. I'm having trouble finding the AVERY labels that I have purchased and have had for a long time. I wish there were easy instructions to create these labels. I put them on rollerball bottles... anyway, I'm struggling with this
I need this too. A page with all same labels.
Well done video and explanation.
My Office 365 doesn't have mail merge Wizard
Thank you! Thank you! Thank you!
This was insanely helpful, more than you can know.
Thanks so much...very clearly explained and helpful!
Thanks very much for this tutorial. It really helped me with my Christmas card mailing labels.
Amazing! couldn't be clearer! Thank you!
It is helpful to me. Thanks Kelvin