Kevin Stratvert
5
How to Mail Merge Address Labels – Office 365
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,…
source
42 comments
Hi Kevin, I love your presentation. I have a question for you. I work a a car dealership and and I now have to print out labels each day for our Advisors, in one of my columns we use vin numbers that have 17 characters. how do I edit that column to only show the last 7 characters at one time.
Great Video!
Great! Thanks
Very helpful thanks – do you have any Microsoft access and Microsoft power point videos
Thank you that was so helpful to follow up with you!
Wow thanks 🎉
It is helpful to me. Thanks Kelvin
What about the rest of it? You showed the easy route, what bout custom labels from a spread sheet?
still a great source for information. Thanks
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.
Yeah mail merge sucks 365. Just pulls the first column from a list
Awesome…I've been pulling my hair out trying to figure this out! Thank you
I’ve hit a snag the address block isn’t including state and zip code how do I correct
You print to pdf so when you’re ready to print you can simply print the pdf not have go back through the wizard again correct
Any chance you’d share your email for very specific questions about why it’s not working forme
You made it so easy for us, thank you veery much!
Please Tell Microsoft a search function to search for your label template would be great
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.
Good presentation. I did have one small problem. My Excel spreadsheet used numeric fields including the field with the ZIP codes. A few of these had leading zeros (Massachusetts) and when the labels were printed the leading zero did not print. e.g. 02474 printed as 2474. If you make the ZIP field text that solves the problem. All the address fields could be text.
I don’t see mail merge wizard
Worked great, THANKS
Thank you so much for this! Super helpful.
can you do this same merge using a word document and not using excel
There is no mailings pivot anymore on the current word and I can't figure out how to do it anymore ahaha.
I can't update labels i can only make 1 label at a time can you please help
so weird I'm not getting the same tool bar options at all. No Mailings tab.
Why is it only showing one page of labels for me when my excel sheet is 300 records?
Great. Can you show how to add 4 lines on the labels (company name).
Super helpful
had to do this for my computer science class great vid thx!!!
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.
What the Heii is that space in front of the first name?
Your zip codes are not correct. They are missing the leading zeroes. I've formatted mine correctly in Excel and they don't merge into Word properly, zeroes are dropped. How do you fix this?
Great presentation. I would like to know more about Pivot tables. Thanks
Very clear video, thank you.
Thank you 4 years later!
What if in excel I have all the adress in one cell ( meaning house number, state etc everything in one cell) because then if I mail merge all of that will come ein one single line in word, which won't work because then I cannot use window envelopes. Is there a way or do i have to painfully separate each address cell in excel before mail merge?
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!!!!!!
This was a big help! Thank you, Kevin!!!
thanks for the precise instructions.
I am trying to create 4up post cards on an 81/2×11 cardstock. Any suggestions? Your instructions doesn't seem to work. Perhaps the concept isnt for separate pieces of mail merge.