How to Mail Merge Address Labels - Office 365
Vložit
- čas přidán 22. 08. 2024
- 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 CZcams 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!
My wife was in a pinch with printing labels for Holiday cards and this video saved so much time for us. Thank you!
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.
VERY WELL DONE!-I HAVE USED THIS VIDEO SEVERAL TIMES OVER THE PAST THREE YEARS TO DO LABELS. THANKS JOHN
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!
Thanks for the refresher, I haven't done this in thirteen years, I used to use mail merge daily.
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.
Thank you. I tried mail merge four times, then followed your tutorial step by step and it worked the first time.
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.
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!
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.
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?
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!
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.
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.
This is EXACTLY what I was looking for and with a clear and easy to understand explanation! Thank you!!
I agree wholeheartedly!
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.
Great video! I struggle printing Christmas card labels every year, and this makes it simple. Thank you!
By far THE BEST VIDEO ever on mail merge. Thank you for the wonderful and easy to understand presentation!!!!!
Thank you kev! Thanks to this video my wife and children have been released from ransom!!
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!
Wow! So helpful! Your step by step saved me hours of trying to figure this out or retype into word. 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.
Super helpful, helping someone at work make labels for holiday cards. Thank you
Thank you for saving my job! I might be able to slide through for a few more weeks. LOL
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.
This enabled me to get my Christmas card list printed once again! Thank God for CZcams, and I mean that literally.
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.
Thank you! I was stuck on a step and couldn't figure out why my merge wasn't working. This helped a lot!
Outstanding! I've been working on this for several days on my own reading Word. Thank you for putting this video together!!😀😀.
Excellent I was able to make my labels with ease with Kevin’s step by step. Thanks.
Glad it helped!
Thanks. I use this for Christmas card labels once a year and never remember how I did it. Don't go away...ever.
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.
Terrific tutorial. I jumped right in, followed your steps and Voila! A perfect merge, ready for printing. Thank you!!!
Thank you so much. This looks so easy. I need to do this for wedding labels
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.
You're a life saver and thank God MS doesn't change much over the years.
Awesome...I've been pulling my hair out trying to figure this out! Thank 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.
Well done.....forwarded to a friend who was struggling with creating mailing labels.....THANKS
Very helpful Kevin! Thank you so much!
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?
Well done. Took all of the uncertainty out of making label mail merge.
Thanks again, I would have spent all day trying to figure this out.
This was a big help! Thank you, Kevin!!!
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.
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.
Thank you!!! You made it so easy.
Thank you. That was easy way better than trying to copy and paste all those addresses.
You made it so easy for us, thank you veery much!
Thank you so much I was at work trying to figure this out for an hour 🤦🏻♀️
I forgot how to do it and this video made it so simple. Thanks
Thank you! This is exactly what I was looking for.
Wow so far the best one I can understand. Thank you
You didn't say what you did at Microsoft, LOL. Great video. Clear and concise information. The length was great. Thank you.
Thank you for being awesome enough to post this. So helpful!
I love your tutorials, many thanks for them!
Regarding this one, I have a question: How do I proceed if I want to make one full sheet of address labels per recipient?
Hi Kevin - After 3.5 hours, I finally found this CZcams 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?
This is amazing. You saved me hours of copy-pasting labels
I learn so much from you. Thank you so much!
Thank you that was so helpful to follow up with you!
had to do this for my computer science class great vid thx!!!
Years ago in my old job, I had to put around 150 address onto labels from an excel spreadsheet. First time I did it I hadn't put next address, so I had 150 labels all with the same address on them.
RE: Background Images:
During Step 3, Arrange your labels. Insert > Pictures > "Right Click" on Image > Select "Wrap Text" > "Behind Text."
This will allow you to use a background image in each "cell" of the label table if you're creating name badges with custom artwork.
I would correct the ZIP codes that begin with a "0" by changing to text for the zip code block in your spreadsheet.
Great job, thank you. It looks as if the name/top row of the labels is not fully aligned to the left margin as the address lines are; is there an extra space before the name? How do you get rid of that so the entire address block is correctly aligned?
So pleased I found this. Thanks from the UK
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.
My Office 365 doesn't have mail merge Wizard
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!
Thank so much for this tutorial. It was very helpful.
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!
useful for very basic intro, but doesn't cover more complex situations such as having a messy address data set in Excel that has to be filtered and cleaned before getting the final labels
You should also check your settings. If the "Confirm File Format" box is checked under "options, advanced' general"
Out here doing the lords work - thank you!
Great presentation. I would like to know more about Pivot tables. Thanks
Well done video and explanation.
Thanks brother! You really saved me ALOT of time and frustration!
I was frustrated until I found this video,Thank You!
Wish I had your knowledge of computers, another helpful video, thanks 👍🏼
Thanks ,excellent tutorial for making personal mailings look professional.
Hmm... somehow Microsoft seem to have made the process more complicated than much older versions (2003 etc). Your video helped me - thanks.
Thanks for the great tutorial man!
This is the best tutorial! Saved me hours at my job !!
Good tutorial brief and to the point. thanks for the refresher.
Thank you so much for this! Super helpful.
so helpful, I found the answer to my question in your tuto - how to print all in one go ;) merci Kev !
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!
still a great source for information. Thanks
Thanks very much for this tutorial. It really helped me with my Christmas card mailing labels.