⏭ Here's a playlist of all my videos on Excel: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

You should run for President, bro. No smoke & mirrors. Easy to follow, comprehensive and no psycho-babble. Straighter than a Marine's salute.

I have been trying to do this all day with just the prompts from Word and your video fixed all the roadblocks!! THANK YOU SO MUCH!!!!

Thanks so much for this video, mail merging seemed to daunting to me. Your explaining and guiding was so so easy that I could not believe I got frazzled by mail merging. Well done. I followed each step pausing the video the complete the step and tahdah, it was done. Thanks a bunch. 🎉🎉🎉🎉🎉

wow, I never knew how to use mail merge... thank you for your clear concise instruction

I've been watching KZfaq videos for a couple of days now, trying to get this in my head. Your video was better than the other I've seen. That was pretty helpful.

Great video! I never knew mail merge would be so easy. Thank you!

Super Helpful video ! I troubleshooted for some time with the printing. For anyone else out there not technically sound like myself, don't forget to adjust the tray settings manually on your printer itself.

Thank you! I have not used this feature in years, so this was an excellent time saver!

Concise, clear and complete - thank you!!!

Thanks! I did it as you went along! Super easy! Great directions.

After a couple of oops, I finally got it! Thanks for the info and your patient way of teaching. 🤗👍

This was such an excellent tutorial. Thank you so much.

You are a legend. this is exactly what I was looking for. thanks Kevin

Great video. Clear, concise, can’t wait to try.

Thanks for recording, best video I watched on this topic

Outstanding! I had forgotten how to use this and your video was spot on what I needed. Thank you.

Appreciate your time and effort. This tutorial really helped me.

Thank you. You made it very clear and easy to understand.

Simple, quick clear instructions!

Thank you for boosting my memory!

I love this steps, very succeeded, very clear and all went very well, thanks for your support for us.

Thanks Kev...good work. Needed that!

Thanks for this great demo!

Thank you so much for this video! I have always made my husband do this because it seemed too daunting, but I have it figure out now!

Great job Kevin. Very useful. Know where to come in future!

Thank you so much. I've got 200+ newsletters to send out, so your video is VERY helpful. Wish me luck! :o) Annette

Thank you!!! Super Easy with your help!! It’s much appreciated! 😊

Perfect. Easy Peasy. Thanks a ton.

Wow. Thanks a lot. This was really helpful. This saves my day

Awesome video and extremely helpful! Thanks!

great job, thank you!!!

Thanks a lot, that was a life saver

Great lesson and thank you!

That was great! Thanks!

@Kevin... thanks for the vid and I recently subscribed to 365. In my Word --> Mailings, I don't have a Wizard option. Any ideas if this was removed from the latest office subscription and what would be the work around? TIA

thank you made this understandable

Thank you! No more labels!!! :)

Sweet sweet Kevin you just saved me so much time and headache. xoxo!

Thanks so much this is more helpful,

Thank you! That was helpful. How can I insert an image or a logo next to the return address?

thanks brother you're a lifesaver

I can use this well for sending letters to my college ministry partners! Thank you

Great video. Thanks a lot.☝

I never could figure it out, thanks

Hello! So cool. Thank you! All my contacts have 2 physical USPS mailing addresses. I have "This is the mailing address" checked for each contact's home address. What is the easiest way to mailmerge the business address all at one time without having to manually go to each contact and checkmark the business address as the mailing address? I've done some due diligence on this and I'm thinking I can create another subfolder with a duplicate contact list and select the business address as the mailing address, that would work, but it would be cleaner if there were some sort of way to toggle between the mailing addresses etc...

Your videos are great! What do I do if the envelop already has a return address?

Thank u soo much sir! God bless

Thanks Kevin!

I had trouble finding your cursor darting around the page. Bigger or darker would have helped. Loved the video!

You literally saved my life

Thanks for that

Video is great! Hopefully I can use it for addressing the envelopes for my daughter's wedding invitations. Is there anyway to change the font on mail merge. I changed the font on my excel spreadsheet but it doesn't seem to be using my font.

Nice. I have an existing main document envelope with logo and name and address. Problem is trying to use a particular group of contacts from my icloud contacts list. If you choose outlook it either uses outlook contacts or all icloud contacts; no longer giving the option of choosing a particular group like before.

Thanks !

Awesome very helpful

In the video the print preview looks as though the return address and the recipient adrress would be printed on an 8.5" X 11" paper and to an envelope.

Kevin, I recalled in 2010-2013, one could address envelopes using MS Word, and we could include USPS pre-sort metered code with the address. Does that metered feature option exist in 2013, 2016, 2019, and or 365?

Hello. I’m using excel to create labels with just data only. Can you use mail merge to import my data from excel and get the labels to fill the columns first (going down the document instead of across?)

can you change the font of the address? great help!! thanks

I'm following your instruction step by step on mail merging. first I go to mailings, then I select start mail merge, in the drop down I only have letters, email messages, envelopes labels, directory and normal word document. I was wondering why my program doesn't look like yours? What must I do to get the step by step drop down added to my selection.

Can I save the setup configuration within word, for envelope printing, for the next time I bring a new list?

Hello can you show us How to print envelopes from a Word letter you just made that will include the sender and recipient on the envelop.

Hi Kevin great video but... how do you get the wizard to show up on the right side of the document. Also when I tried to select the cells it tells me there is no data, where I have 34 rows of data. I do have titles like name and address but it doesn't put check boxes in my excel spreadsheet either. So I'm doing something wrong. Can you tell me how to get the side wizard first?

How can you select the fonts and font sizes for the address and return address data. Can you move the location of the address and return address info on the envelope? Thanks

Hello Kevin and Seasons greetings Sir. I have Office 2003 and when I use mail merge with Excel as the database I cannot add, delete or edit through Word, only Excel as the Word mail merge recipients edit box just below "clear all" is unavailable. When I use an Access database or type a list through Word I can add, delete or edit through either one. Am I doing something wrong. Thank you.

Thanks for your instructions. I tried to do the mail merge on customer envelop size, 7 x 5. Everything works according to your instructions. I typed in the return address. Then when I chose “address block”, it appears at the return address area, not the delivery address area. I put my cursor around the delivery address area, but it jumped right back to the return address area. I then tried #10 envelops. Still the same. Would you please let me know how can I fix this problem? Thanks very much.

Can you print on the back of the evenlope with this function too?

I'm doing everything the same way you are, but the street names are not popping up in the address block, but they're showing in the recipient list. How do I get them to show? Also, is there a way to change the layout of the addresses? (ie. I want the zip codes on their own line at the bottom)

I do not have the mail merge wizard option your talking about. Mine doesn't show up on my list. How do I find that? thanks

Thank you. I could use a print format tutorial. I keep getting print fields all over the place in actual printing. It looks fine on the screen, but either prints blank or very strange margins.

thanks Kevin. great video. I am having a minor issue that I noticed you had also but you did not notice. The NAME line is indented 1 space to the right so that it does not line up with the address and city lines. you did not notice on your example. I could not figure it out

Hi Kevin. I have over 300 recipients. I did the mail merge ok but want to take it to Fedex for them to print. When I tried to save the completed merged document, it only saved the one recipient on the screen. How do I save the merged file for printing later?

Great videos. Why did you use the "address block/next record- address block" in the merge labels video, but not the merge envelopes video? Does it just advance to the next address automatically within the envelope program vs the label program?

Kevin, why is word putting my addresses in the return address field. When I get to arrange your envelope and at inset merge fields I click insert, which is in the right order, it puts the first name in the return address field.

Thanks

I run a business where I send mail on behalf of my clients. Is there a way to set it up where the recipient is changed? For example, if I need to send three different letters to 3 different credit bureaus for the same client how could I make that easier?

I'm doing wedding invitations. The inner envelopes will have only the name of the guest. sometimes their kids names will be below theirs. How do I center each name correctly on the envelope? I don't see where the 3 usual justify choices are available like they are in a regular word document.

I am using a excel sheet with 180 addresses. my printer only holds like 10 envelopes at a time. every time printer says empty, I put in envelopes and press done on printer. Some how Word is not printing in sequence like the Excel sheet has names. It skips names / rows and column and not in order.

All was good until I got to the Browse part. I found my Excel sheet and clicked on Open. Then I get a box "Confirm Data Source" that defaults to OLE DB Database Files. ???? If I then click on "Show All" my only Excel choice is MS Excel Worksheets via DDE (*.xls) ???? and Word will not connect to this. Help!

I dont have the wizard? Have mac word 365

Any suggestions for printing on an A2 envelope in 365? I can't get it to work.

How do I perform an envelope mail merge with an already created mail merge letter that includes all of the addresses?

is there a way to remove the 1 spacebar from the beginning of each name?

Kevin, this doesn't work for Office 365 on a MacBook Pro. The interface is different. I keep searching but can't find video on how to do it on Mac. Can you assist? THANKS IN ADVANCE for your help!

Hi, could show how to use hyperlink in excel.

Mine looks a lot different from yours how do I do this I just got this today

i have envelopes with return address on them. so when i follow your directions my send to address goes up in left corner instead of middle of envelope

How can I use the exact procedure that you've so well presented, BUT entirely exclude a Return Address since the Return box cannot be blanked or deleted? Thank you!

My word does not have the mail wizard option? I can only click directly to envelopes

Why did they stop 6 3/4 envelopes from printing? It is on word but when printing it is not recognized.

How do you save that merge if used weekly

I'm having the worst time trying to figure this out. I have a system that exports names and mailing addresses in to word document but I can't figure out how to make each of those names/addresses attach itself to a single envelope. Every time i try, it only prints one column of names/address... help! haha

What happens if my list is not in excel...it is just 50 addresses in a word doc. ?

Why isn't this an option in outlook itself? I have to go into another program to go back to the program with the information to print. Is there a why to print envelopes DIRECTLY FROM OUTLOOK? Why isn't there an option to choose a printer without having to go back to PRINTERS CHANGE THE DEFUALT than open word? Print the envelope on the printer you want and than go back and change your default printer back to the one you want.

I'm still looking for mail merge wizard

I have office 365 and a mac. I know how to do mail merge in office on a PC. I do not have the wizard and am struggling selecting my envelope choice, position of my return and recipient address. (Data sheet is ready to go, I was able to my letters.)

Hello, can we do the same with labels ?

I don't get a "Mail Merge Wizard" option.

Has anyone printed addresses on a stack of envelopes? Seems like it might cause printing issues.