Тёмный

How to do a Mail Merge in Microsoft® Word for Mac® 2016 

Avery Products
Подписаться 16 тыс.
Просмотров 232 тыс.
50% 1

If you use Microsoft Office 2016 with a Mac computer, you can easily import addresses or other data from an Excel spreadsheet or from your Apple Contacts and place them onto Avery labels, name badges, name tags or other products to edit and print using Microsoft Word for Mac. See the steps to mail merge from an Excel spreadsheet onto an Avery template, making preparing for mailings and meetings a breeze.

Опубликовано:

 

16 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 52   
@erikawhit87
@erikawhit87 Год назад
After being brought to tears trying to create address labels for the first time using a Mac, I found this video and had my labels made within 5 minutes. THANK YOU!
@debbiemellberg8077
@debbiemellberg8077 2 года назад
Short and to the point. No fluff, just the information necessary to make this work on my Mac in less than 3 minutes. Thank you!
@Whisperland
@Whisperland 5 лет назад
I spent hours trying different tutorials on how to do this -- yours is the only one that actually worked! Thank you!
@GFKopf
@GFKopf 4 года назад
This is a refreshingly easy and accurate tutorial. Thank you Avery!
@richardbryanesq
@richardbryanesq 2 года назад
This is definitely the best tutorial, most especially for acknowledging that some versions of Word have slightly different tool options.
@AveryProducts
@AveryProducts 2 года назад
Wow, thanks! That's great to hear :)
@karenpoehailos8714
@karenpoehailos8714 2 года назад
This is the only tutorial I found tonight that actually made it work. Thank you!!!
@robinyamamoto6834
@robinyamamoto6834 9 месяцев назад
Accurate and to the point. My annual struggle to output a set of labels for Christmas cards is (finally!) solved. :-)
@jamiesullivan5830
@jamiesullivan5830 3 года назад
Best tutorial out there. Very simple and easy to follow. Thank you!
@blessinghome503
@blessinghome503 Год назад
This is the best tutorial the step by step makes it so easy to follow. Thank you so much Avery!
@susanpiepho2021
@susanpiepho2021 4 года назад
This was extremely helpful. It works, but you must follow it carefully! Thanks for producing this!
@alisoncameron2783
@alisoncameron2783 2 года назад
FANTASTIC! Like others, I have spent ages looking for a tutorial which matched my software and Mac - and this works!
@michaelcronin3224
@michaelcronin3224 9 месяцев назад
Clear and accurate. Microsoft changes its unclear and useless guidance every year. You are a lifesaver.
@doug4807
@doug4807 2 года назад
Great tutorial! I've seen some ridiculously complicated tutorials, including from Microsoft, to perform this rather simple task. Thanks for this as it saved me much frustration.
@earthangel8875
@earthangel8875 9 месяцев назад
Thank you Avery I have been using your products for many years. I appreciate this video. It helped me out on my PC. Many Thanks, Angel from The Bay
@telaine7266
@telaine7266 Год назад
YOU are a life saver. 💜 Simple and easy to follow tutorial! Thank you!
@ThePaellaBoy
@ThePaellaBoy 4 года назад
I was in quite the pinch and this tutorial saved my life, thank you very much!
@juliehicks59
@juliehicks59 4 года назад
Thank YOU so much, I have been struggling with this for so long! Best video out there!
@yeminne
@yeminne 5 лет назад
Very helpful and about time for an updated video on mail merge!
@MyNimrods
@MyNimrods 2 года назад
excellent - learned how to do this in minutes. Thank you.
@udaymahajan3876
@udaymahajan3876 3 года назад
Thanks a lot!! It was so difficult previously You earned a SUB👍🏻
@paulemch3614
@paulemch3614 5 лет назад
Excellent tutorial! Well done and clearly explained. The only one I found anywhere that was 100% helpful!
@cherylholz4325
@cherylholz4325 5 лет назад
Thank you thank you thank you! Didn't realize till I sat down to do price tags at the last minute that the new version worked completely different than the last one. Word help refers to tabs that you can't find. Yours was excellent. The only thing not covered is doing different format for the text.Thank you thank you thank you! Didn't realize till I sat down to do price tags at the last minute that the new version worked completely different than the last one. Word help refers to tabs that you can't find. Yours was excellent. The only thing not covered is doing different format for the text. Pull down format and font once you have the text highlighted and you can make bold or italic. One thing I'm not sure of is when you save it, it saves all of the merge data with it? So if I want to save this format that I just created I would save it as a template Pull down format and font once you have the text highlighted and you can make bold or italic. One thing I'm not sure of is when you save it, it saves all of the merge data with it? So if I want to save this format that I just created I would save it as a template?
@AveryProducts
@AveryProducts 5 лет назад
Hi Cheryl, thanks for your feedback! When you go to save, it will save the existing project/formatting. If you need additional insight please reach out to our care team and they will be happy to answer any questions! Avery.com/help
@davidgrant8628
@davidgrant8628 8 месяцев назад
awesome - thank you for posting! Works perfectly.
@lovdeepgahunia1692
@lovdeepgahunia1692 3 года назад
Yeah finally, that stupid cell range thing was mad annoying, this was a very helpful video.
@MrCaruanaDingli
@MrCaruanaDingli 3 года назад
OMG This was the very best explanation of all. lt saved me!!!!!!!!!!!!!
@cobysillers1
@cobysillers1 2 года назад
My list has more than 30 entries and I can only get one page of entries to show/merge/print. What am I not doing?
@adrianabulla8186
@adrianabulla8186 2 года назад
You just save my life lol!! Thank you!!!!!
@BobBurnsOB
@BobBurnsOB 4 года назад
Thank you, was very helpful and easy to follow EXCEPT that I have M$ Excel 2019 which has no "Update Labels" button but has a yin-and-yang-like-double-arrows button which reads "Update Labels" only when the cursor is over it.
@AveryProducts
@AveryProducts 4 года назад
Hi Robert! Feel free to reach out to our help center and they'll be able to assist! Avery.com/help
@taimoursherkhan4166
@taimoursherkhan4166 4 года назад
Such a great help
@CandiiCaine2001
@CandiiCaine2001 4 года назад
thank you so much for this!!
@buckmanriver
@buckmanriver Год назад
Amazing!
@Ransunboi
@Ransunboi 2 года назад
perfect for mac, thanks!
@jandook6120
@jandook6120 2 года назад
Thank you - your tutorial is easy to follow however I have an issue in that I can merge fields etc however when I select PREVIEW RESULTS all of the data (the merged fields) disappears. If I turn Preview Results off, the data returns. Same thing if I go to Finish & Merge - the data disappears and I don't have any labels with names etc in them and hence nothing to print. I would appreciate any help. I am on Word for Mac v16.32
@dazzlings
@dazzlings 5 лет назад
Insert merge fields isn't lit up. Can't click on it!
@dianethurber5204
@dianethurber5204 3 года назад
Thank you Soooo much
@sarahadam872
@sarahadam872 2 года назад
I am using the Avery templates and the update label button is inactive?? I can't move from there.. any help ? I am using 8161 version.
@eleanorpowell6840
@eleanorpowell6840 3 года назад
for easy cutting
@lorettadelange8494
@lorettadelange8494 3 года назад
I'm missing the "Update Results" button and can't get beyond this step.
@AveryProducts
@AveryProducts 3 года назад
Hi Loretta, thanks for reaching out! Feel free to call or chat with our team at Avery.com/help and they'll be happy to assist you
@lamyaalhazzani3880
@lamyaalhazzani3880 2 года назад
how to merge mail to pdf ?
@adventpropertiesinc.8883
@adventpropertiesinc.8883 4 года назад
I don't know how or why but "Preview Results" is not active for me to click and I am stuck. HELP!
@AveryProducts
@AveryProducts 4 года назад
Hi there, it could be your browser! Try a different one or restart the page. If you're still having trouble feel free to reach out to Avery.com/help
@BobBurnsOB
@BobBurnsOB 4 года назад
In M$ Excel 2019 it's just under the "Mailings" tab. Maybe you didn't properly do a preliminary step.
@ryanbeatty4128
@ryanbeatty4128 5 лет назад
Anyway to keep formulas?
@AveryProducts
@AveryProducts 5 лет назад
Hi there, please reach out to Avery.com/help
@seanicusvideo
@seanicusvideo Год назад
Using this version of Word for Mac-- When I hit "OK" in the Open Workbook dialogue, the cells aren't populated with that "
@seanicusvideo
@seanicusvideo Год назад
also: the choices under "Insert Merge Field" don't look like that. it's got all these old fields from past merges or something
@suheyryedmen8675
@suheyryedmen8675 2 года назад
how to convert it to pdf?
Далее
Mini bag sealer
00:58
Просмотров 4,2 млн
How to Work with Text and Images in Microsoft®  Word
3:58
Printing Tips for Avery® Labels, Cards and More
1:48
Просмотров 678 тыс.
Laboratory Label Webinar
38:03
Просмотров 265 тыс.