this was great, however, when viewing envelopes, the font, size and spacing (two spaces instead one one) was different than selected in the delivery address block. the sender address was correct. How do you change this? thanks, Tom D.
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. 🎉🎉🎉🎉🎉
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.
I've been watching CZcams 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.
@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
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?
Hey karen - with the address labels, you have multiple labels appearing on the same page, so you need to let word know to advance to the next record. With envelopes, you only have one address per page so there’s no need to tell word to use the next record... it’ll just do so automatically when advancing to the next page. Cheers!
@@KevinStratvert Thanks Kevin. I was thinking that you could end up with multiple envelopes with the same initial address by mistake without the next record--address block.
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.
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.
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.
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.
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?
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...
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?
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
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.
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!
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!
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.
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'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.
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?)
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.
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?
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 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?
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
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
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.
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!
Try just hitting the space key in the return address area. This is technically a character and the software will see it as such but nothing will print.
⏭ Here's a playlist of all my videos on Excel: czcams.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
So this automatically always puts in the return address?
this was great, however, when viewing envelopes, the font, size and spacing (two spaces instead one one) was different than selected in the delivery address block. the sender address was correct. How do you change this? thanks, Tom D.
You should run for President, bro. No smoke & mirrors. Easy to follow, comprehensive and no psycho-babble. Straighter than a Marine's salute.
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. 🎉🎉🎉🎉🎉
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.
wow, I never knew how to use mail merge... thank you for your clear concise instruction
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!!!!
I've been watching CZcams 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!
Outstanding! I had forgotten how to use this and your video was spot on what I needed. Thank you.
I had trouble finding your cursor darting around the page. Bigger or darker would have helped. Loved the video!
You are a legend. this is exactly what I was looking for. thanks Kevin
@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 so much. I've got 200+ newsletters to send out, so your video is VERY helpful. Wish me luck! :o) Annette
Perfect. Easy Peasy. Thanks a ton.
of course, happy to help!
Great job Kevin. Very useful. Know where to come in future!
Simple, quick clear instructions!
I love this steps, very succeeded, very clear and all went very well, thanks for your support for us.
Sweet sweet Kevin you just saved me so much time and headache. xoxo!
Great lesson and thank you!
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!
Thank you. You made it very clear and easy to understand.
Thank you!!! Super Easy with your help!! It’s much appreciated! 😊
After a couple of oops, I finally got it! Thanks for the info and your patient way of teaching. 🤗👍
You literally saved my life
Great video. Clear, concise, can’t wait to try.
Thanks! I did it as you went along! Super easy! Great directions.
Concise, clear and complete - thank you!!!
Awesome video and extremely helpful! Thanks!
Thank you! I have not used this feature in years, so this was an excellent time saver!
Wow. Thanks a lot. This was really helpful. This saves my day
This was such an excellent tutorial. Thank you so much.
Thank you! That was helpful.
How can I insert an image or a logo next to the return address?
Appreciate your time and effort. This tutorial really helped me.
thanks brother you're a lifesaver
Thank you for boosting my memory!
I can use this well for sending letters to my college ministry partners! Thank you
Thanks for this great demo!
Thanks Kev...good work. Needed that!
Thanks for recording, best video I watched on this topic
That was great! Thanks!
Thank you! No more labels!!! :)
Your videos are great! What do I do if the envelop already has a return address?
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?
Hey karen - with the address labels, you have multiple labels appearing on the same page, so you need to let word know to advance to the next record. With envelopes, you only have one address per page so there’s no need to tell word to use the next record... it’ll just do so automatically when advancing to the next page. Cheers!
@@KevinStratvert Thanks Kevin. I was thinking that you could end up with multiple envelopes with the same initial address by mistake without the next record--address block.
Great video. Thanks a lot.☝
Thanks Kevin!
Thanks a lot, that was a life saver
Awesome very helpful
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.
me too! What is the solution?
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.
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.
thank you made this understandable
I dont have the wizard? Have mac word 365
I never could figure it out, thanks
Thanks so much this is more helpful,
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.
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
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?
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...
great job, thank you!!!
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.
Thank u soo much sir! God bless
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?
Thanks !
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
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.
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!
can you change the font of the address? great help!! thanks
Got one for Microsoft 365 on a Mac? Doesn't have a Wizard option.
Can I save the setup configuration within word, for envelope printing, for the next time I bring a new list?
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!
Why did they stop 6 3/4 envelopes from printing? It is on word but when printing it is not recognized.
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.
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)
How do I perform an envelope mail merge with an already created mail merge letter that includes all of the addresses?
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 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
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?)
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.
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.
I don't get a "Mail Merge Wizard" option.
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?
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 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?
Any suggestions for printing on an A2 envelope in 365? I can't get it to work.
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
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
Thanks
Can you print on the back of the evenlope with this function too?
Thanks for that
is there a way to remove the 1 spacebar from the beginning of each name?
What happens if my list is not in excel...it is just 50 addresses in a word doc. ?
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.
How do you save that merge if used weekly
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!
Try just hitting the space key in the return address area. This is technically a character and the software will see it as such but nothing will print.
I'm still looking for mail merge wizard
Mine looks a lot different from yours how do I do this I just got this today
Has anyone printed addresses on a stack of envelopes? Seems like it might cause printing issues.
How to print envelops without a return address?
Mail Merge is cool and all but let's talk about big wall!
That won't print on envelopes it will only print on the 8.5x11 sheet