⏭ Here's a playlist of all my videos on Excel: kzitem.info/door/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@servant4thelord562
3 жыл бұрын
So this automatically always puts in the return address?
@tomdrost3522
2 жыл бұрын
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.
@darylmichael7
4 жыл бұрын
You should run for President, bro. No smoke & mirrors. Easy to follow, comprehensive and no psycho-babble. Straighter than a Marine's salute.
@omgkaty
8 ай бұрын
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.
@kimsteele7714
Жыл бұрын
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. 🎉🎉🎉🎉🎉
@jenniferlanham8482
3 жыл бұрын
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!!!!
@tinacolton5432
2 жыл бұрын
I've been watching KZitem 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.
@nicolemclaughlin9858
5 жыл бұрын
wow, I never knew how to use mail merge... thank you for your clear concise instruction
@jonwoodson7537
10 ай бұрын
Outstanding! I had forgotten how to use this and your video was spot on what I needed. Thank you.
@itsemiloveyou
Жыл бұрын
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!
@shannabatista1826
4 жыл бұрын
Great video! I never knew mail merge would be so easy. Thank you!
@AnneRemaley
5 ай бұрын
Great lesson and thank you!
@janaesmith8938
2 жыл бұрын
Sweet sweet Kevin you just saved me so much time and headache. xoxo!
@ElizabethLintner
5 ай бұрын
You literally saved my life
@zachdodge8666
2 жыл бұрын
I can use this well for sending letters to my college ministry partners! Thank you
@gonti990
Жыл бұрын
Thank you!!! Super Easy with your help!! It’s much appreciated! 😊
@LondonBandara
2 жыл бұрын
I love this steps, very succeeded, very clear and all went very well, thanks for your support for us.
@katiefoye4173
Жыл бұрын
I had trouble finding your cursor darting around the page. Bigger or darker would have helped. Loved the video!
@Chux48
3 жыл бұрын
You are a legend. this is exactly what I was looking for. thanks Kevin
@nicolestevescott1240
2 жыл бұрын
Simple, quick clear instructions!
@williammcquinn8037
2 жыл бұрын
thanks brother you're a lifesaver
@abundareUK
3 жыл бұрын
Great job Kevin. Very useful. Know where to come in future!
@angelarogers7029
3 жыл бұрын
After a couple of oops, I finally got it! Thanks for the info and your patient way of teaching. 🤗👍
@ATUCOMS
4 жыл бұрын
Thank you! I have not used this feature in years, so this was an excellent time saver!
@jeffbreedlove7437
3 жыл бұрын
Thank you. You made it very clear and easy to understand.
@elainaricci1501
3 жыл бұрын
Thanks! I did it as you went along! Super easy! Great directions.
@sudeerakelum3258
2 жыл бұрын
Wow. Thanks a lot. This was really helpful. This saves my day
@1886491
4 жыл бұрын
Concise, clear and complete - thank you!!!
@billdodds5255
4 жыл бұрын
Perfect. Easy Peasy. Thanks a ton.
@KevinStratvert
4 жыл бұрын
of course, happy to help!
@winonapentecostalchurch9803
Жыл бұрын
Awesome video and extremely helpful! Thanks!
@ruthhunt8196
2 жыл бұрын
Great video. Clear, concise, can’t wait to try.
@celilamartin1072
3 жыл бұрын
Appreciate your time and effort. This tutorial really helped me.
@dr.janiceboursiquot6349
4 жыл бұрын
This was such an excellent tutorial. Thank you so much.
@rogersanluis1451
2 жыл бұрын
Great video. Thanks a lot.☝
@rabaile1
4 жыл бұрын
Thank you so much. I've got 200+ newsletters to send out, so your video is VERY helpful. Wish me luck! :o) Annette
@peggydyess1589
3 жыл бұрын
Thank you for boosting my memory!
@kathycresswell8353
Жыл бұрын
That was great! Thanks!
@stevenaylor9514
4 жыл бұрын
Thanks for recording, best video I watched on this topic
@alpridemore9314
4 жыл бұрын
Thanks Kev...good work. Needed that!
@MrLastLOTR
3 жыл бұрын
Thanks for this great demo!
@elijah48
Жыл бұрын
Thanks Kevin!
@amyboswelll597
3 жыл бұрын
Thank you! No more labels!!! :)
@greisycanseco4982
Жыл бұрын
Awesome very helpful
@marcusdelacruz4730
4 жыл бұрын
I never could figure it out, thanks
@Zwenni
3 жыл бұрын
Thanks a lot, that was a life saver
@cleofasfamilyvideos91
3 жыл бұрын
Thanks so much this is more helpful,
@jeffrey_njrealestate
3 жыл бұрын
@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
@kirstensandin2319
4 жыл бұрын
thank you made this understandable
@xvzw
Жыл бұрын
Thank you! That was helpful. How can I insert an image or a logo next to the return address?
@tamanpreetsahni3757
3 жыл бұрын
Thank u soo much sir! God bless
@zang9147
3 жыл бұрын
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.
@olvoffice801
2 жыл бұрын
me too! What is the solution?
@canada7978
4 жыл бұрын
great job, thank you!!!
@anotherindividual5799
3 жыл бұрын
Thanks !
@Limey_Boy
4 жыл бұрын
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.
@joystump4617
4 жыл бұрын
Your videos are great! What do I do if the envelop already has a return address?
@debbiemathosian7854
Жыл бұрын
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.
@latwonwhitby7335
8 ай бұрын
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.
@johnswenning3322
2 жыл бұрын
can you change the font of the address? great help!! thanks
@karenwhite8969
5 жыл бұрын
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?
@KevinStratvert
5 жыл бұрын
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!
@karenwhite8969
5 жыл бұрын
@@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.
@viccserer9841
2 жыл бұрын
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
@keepagreement
4 жыл бұрын
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...
@NoelGarland
4 жыл бұрын
Thanks for that
@micmica1827
Жыл бұрын
Thanks
@lizblack4003
Жыл бұрын
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?
@jR060t
2 жыл бұрын
Mail Merge is cool and all but let's talk about big wall!
@rafaelgarcia5331
4 жыл бұрын
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.
@FireeIced
4 жыл бұрын
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.
@danny4866
2 жыл бұрын
Can I save the setup configuration within word, for envelope printing, for the next time I bring a new list?
@georgiap8427
11 ай бұрын
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!
@kathymetz612
2 жыл бұрын
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
@ianthomson5255
4 жыл бұрын
I dont have the wizard? Have mac word 365
@DianeTerbrock
Жыл бұрын
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!
@LouddnPraisie
Жыл бұрын
Why did they stop 6 3/4 envelopes from printing? It is on word but when printing it is not recognized.
@robertmann1333
2 жыл бұрын
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!
@seylerfam7025
2 жыл бұрын
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.
@nanc547
2 жыл бұрын
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?)
@LaurelKashinn
29 күн бұрын
Got one for Microsoft 365 on a Mac? Doesn't have a Wizard option.
@JaniceMarcantel
Жыл бұрын
How do I perform an envelope mail merge with an already created mail merge letter that includes all of the addresses?
@lisarenn3540
3 жыл бұрын
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.
@grantshort
4 ай бұрын
I'm still looking for mail merge wizard
@lancelanza9110
4 жыл бұрын
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.
@leonmarcuscherry5118
3 жыл бұрын
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?
@jeremyacupp
3 жыл бұрын
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
@robwin0072
2 жыл бұрын
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?
@arachne4757
3 жыл бұрын
Any suggestions for printing on an A2 envelope in 365? I can't get it to work.
@joslinbucholz7042
3 жыл бұрын
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
@paulharrison3651
7 ай бұрын
I don't get a "Mail Merge Wizard" option.
@margarettrakas3398
3 жыл бұрын
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.
@RJINN
4 жыл бұрын
What happens if my list is not in excel...it is just 50 addresses in a word doc. ?
@robertdavis472
2 жыл бұрын
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
@gghostrrider
Жыл бұрын
Has anyone printed addresses on a stack of envelopes? Seems like it might cause printing issues.
@evelynrussell2834
8 ай бұрын
How do you save that merge if used weekly
@dominictascarella3936
Жыл бұрын
No "Mail Merge Wizard" shows up in the tab. Just Normal Word Document
@wninal
Жыл бұрын
same
@alexisarment4592
4 жыл бұрын
Can you print on the back of the evenlope with this function too?
@jorgeanayajr4465
3 жыл бұрын
is there a way to remove the 1 spacebar from the beginning of each name?
@darrenrodrigues3596
4 жыл бұрын
Hi, could show how to use hyperlink in excel.
@billie-annwollschlager4151
2 жыл бұрын
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)
@jeffgarner3178
3 жыл бұрын
I want to do just ONE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@dfwmb000
4 жыл бұрын
Mine looks a lot different from yours how do I do this I just got this today
@bakinginthelaw9592
3 жыл бұрын
Having trouble printing on a 5x7 envelope...
@mensahrobinsonassistant2372
3 жыл бұрын
That won't print on envelopes it will only print on the 8.5x11 sheet
Пікірлер: 131