How to Mail Merge Letters - Office 365

[@mikekerr2282]

I remember having to type the individual letters to several people. This feature is great. Your tutorial was excellent, voice tone, display menu selections and instructions were the clearest of several videos that I found. I only do this once a year, just saw this and you made my life much easier. Thank you.

[@veshexercise]

Thank you Kelvin for sharing your ideas with us, I have just made my first mail merge successfully, am so happy right now💕💕💕💕💕

[@harmonybetancourt5791]

Thank you very much to this man, he made me understand mailmerge better than my school teacher does

[@JocelynCleolette]

Thanks a lot for this helpful video! I have just done my letters 😊

[@aimeeamos7297]

THANK YOU VERY MUCH KEVIN, THE training on mail Merge is wonderful. Thank you

[@JesseSabo]

It's like Madlibs of Christmas letters: Hello _____, I hope you are _____ about _____ as we celebrate the season with Joy. *gasps of disbelief at your thoughtfulness

[@charlestoneoyoo]

Lifesaver, up to the point. Thank you

[@smashlee6068]

This was so helpful to me today! So easy to understand. Thank you!

[@kathalterado2336]

I like this tutorial,I really need this for our school activity. Thank you

[@rookieman_]

Whoa.. I'm also here because of School. LOL

[@Mandolin1944]

Great video well explained. How about a video on how to create a new mail merge template document -- preferable one with you company's letterhead to top?

[@dizzaflores2930]

Thank you , this video help me so much in my activity in Teaching and learning 2. We need to make a merge letter to the parents of the students in their progress in academics.

[@raymondbeeney8358]

I would like to see how to email from a list in an Excel spreadsheet.

[@amyfitzgerald1232]

This was super helpful! I haven't done this in a year so it was a great refresher.

[@sweetest_of_all_honeys1993]

Thank you so much. This was very helpful and straightforward.

[@mmitchellhouston]

Thanks. I don't do this often, so a uick refresher course was VERY helpful.

[@billrichmond1110]

thank you. This was really well explained!

[@Bonolo_Mamosana]

Can you please do a video explaining amortisation in excel that has changes in inerest rate

[@ChoclateGoddezz]

Hi Kevin, I have two questions. 1.) Can I mail merge multiple letters at one time? 2.) Also, with letters being in two different languages?

[@daquanwilliams3930]

Thank you a lot this really helped me out for my SBA👍

[@paromitaganguly4409]

Hi Kevin, your video tutorials are extremely helpful. Please post tutorial on Quick Parts & Building Blocks in MS Word. Thank you.

[@godwinuche4669]

Thank you 🙏 I just want to be learning something about tech each day of my life

[@richardterrell5309]

Thank you Kevin, I expect to learn more watching your other videos, so I have subscribed

[@linderlaw4298]

Thank you once again ... Have learnt so much from your tutorials 👌

[@Moundofspring]

Hi. Why can’t I see the set up wizard as an option from the drop-down? I’m in 365 using Mac.

[@MonikaR2006]

Thank you Kevin. Do you have a tutorial to create an invoice in excel (or word) from an excel timesheet, for specific dates per customer? Would love to see that 🙏

[@PrabhakarMurthy-y5s]

Great Stuff Kevin, Thank you

[@meighanmcwilliam8782]

Hi Kevin...you do a great job explaining the process however, for some reason, my version of MS 365 doesn't have the 'wizard' choice. I have to start with mail merge, select recipient from existing list. When I get up to the preview results step, I can see all the imported information on my letter template for all my recipients. When I choose 'finish and merge' and choose 'print documents', my printed output is missing doesn't all the imported information I was able to see in preview. Can you explain what might be happening here? thanks

[@tiffanymello8181]

Thanks for the video Kevin, can you offer a solution to mail merge to individual PDFs named by one of the fields in the source file? For example, this mail merge tutorial is for one PDF but I would like to save each letter individually by "Full_Name" for example. Ultimately, I will need to email them individually (or in a zip file). Let me know :) Thanks!

[@vishalmasurkar79]

Do we have any solution for this issue ?

[@dianarandolph5519]

Hello, love your video. I would like to send letters through email. Would I insert the email address in the address area? Please let me know what I can do. Thanks

[@carlchristopher2534]

Hey Kevin that was a great mail merge 101 video. I need mail merge 201. I had a very difficult time where you insert your mail merge in a document learning how you have to save it in a special way to keep the font style of the merged data. Then is there anyway just say you had 20 letters to do all different individuals is there a way to save the documents individually so that you could attach that document to a email ??? Thanks much, Carl Christopher P.S. as full disclosure I do NOT work for Microsoft ... Lol

[@KevinStratvert]

Hey Carl- this video will show you how to send attachments with mail merge: kzbin.info/www/bejne/r5vCpGaZmcuJers

[@richardcarmelasandradouris9767]

This was extremely helpful,

[@mikecarter230]

Please remove the reference to Office 365. Merge does not exist on that. This video is how to merge letters with the desktop version of Office. If you only have Microsoft 365, you cannot merge documents.

[@charlotteengerer6751]

Hey Kevin, I've used a number of your videos to help me with challenges in Excel, and find them super helpful, and while I have used mail merge for many years, I have run into a challenge that I'm hoping you can help me with. I am working in MS 365 (recently converted), and attempting to distribute a document by mail merge to about 1,000 employees; while the merge functions no problem, the mail step does not seem to work. It appears that my email account is set up in Word, but I cannot figure out why it's not working. Any chance you can assist me with this?

[@sobiuba386]

Nice video, thank you so much!

[@ParadelaC]

I dont have Mailings tab on my word online version

[@leahachungo3390]

Hi Kevin the tutorial is very helpful

[@JudyKaminski-e1y]

Thank you ! I needed this for work !

[@amittiwari340]

Pls advise how to use mail merge for Bulk email in Outlook 365?

[@vincentvesaklee8154]

Can We Print the pdf individually but at once like for maybe 50 names?* (50 individual for 50 pdf for example)

[@JH-wo6zd]

Did you find out the way?

[@brunoveiga6113]

Good videos , however i still can not see how to change the content off the letter. Eg a Different framework of aggreement

[@Homegrownninjas]

Looks like an epic climb! I'm going to guess Squamish!

[@Dragoninja]

Mr. Stratvert, U used Excel to create your Data Base of Contacts. My Question is Can U Use Access to Create the Contact Data Base?

[@seyoumkassa7684]

Hey. Thank you. How can I print each letter as separate pdf?

[@ashwinya2425]

Can we do mail merge in word 2007?

[@adamdowling5482]

Great video!

[@cliffp4968]

Can you confirm that this feature isn’t available in the free web based version of word? I don’t have a “mailings” option on the free version.

[@大嘴夏]

Hi Kevin, thank you for your sharing. I have 2 questions: 1. how to find the Word startup folder for a MacBook? 2. I go through all mail merge (sending e-mails) process, but those e-mails didn't send out, they stayed in my outbox, I have to click the button "send" manually. Do you know what should I do? Thank you very much. Irene

[@danielholland7822]

Hey, can you mail merge from another platform into Word, such a table within Notion?

[@rochelkreiman5284]

How can i merge fraction? Looks fine in database but doesn't convert in my letter

[@loridonahoo4616]

I have watched several of you mail merge videos, but Never see anything about using RE: on the far right. I need RE: Subject matter, person's name on line 2, person's address on line 3, and line 4 city, state & zip. Would this be called a unique field? Also, how do you maybe "right justify" or line everything on the far right so it lines up. I have subscribed to your channel - you do not answer questions or provide additional tutorials for formal business letters with RE: subject matter on the far right. I would like to communicate with you or someone and have a new tutorial just for this topic.

[@ernestocastruitajr.9620]

Hi Kevin, Is there a way to Mail Merge a letter from two difference worksheets?

[@pouncer84]

Is there a way to do this when the certificate is in power point instead of word?

[@razelsantiago5050]

Thank you so much. I just follow your video, it helps me a lot for my project. Thank you. God bless.

[@cheyanaxo523]

im doing chapter 5 for ms word and it does not want to merge the letter into an evelope? i need help please

[@davidwiley5005]

Help. I am trying to add "Dr." to the names in the address box and greeting line. Do I have to add that in Excel or can that be done in mail merge

[@ITSKILLSACADEMY]

I like this guy intro, great tutorial

[@vvvrcpa9088]

I use mail merge frequently. One aspect I still haven’t perfected is how to insert number fields in the document and have the commas and decimal points line up in a column of eight items. I send out 600+ letters and amounts are different in each of the 600 letters. For some letters the amounts might be in the hundreds of thousands for one field and less than $100 in a field below that. Sometimes they line up and sometimes they don’t. How can I get consistent results? I’m in Office365. Thanks!

[@johnstath9666]

Why cant you insert a signature line created by the add on Draw?

[@cwhrlng]

Can you do this with emails?

[@antoniobrown1371]

How do you set a timer so all emails dont send at once?

[@jw1054]

How would you remove a data source to the same letter? Had to block out first four digits of an account # . After modifying the excel spread sheet ,not taking the updated list. Still showing full account #

[@latifahfahad6121]

Can we send mail merge with personalized CC or BCC? Without adds in?

[@navneetmanaksia3667]

How can I save the different letters separately? Not 1 file having say 50 letters but 50 different files.

[@NoExcuseSirr]

Thank you!

[@deel.pearson4542]

Formatting in mail merge of labels.

[@henrydiaz8906]

headers and Footers don't appear after mail merge

[@zothanimakhanya]

Thank you so much bro

[@nilspalsson3725]

HI if i only use the online version of M 365 and i want to use merge. Wish solution are the best!?

[@TheCaptKit]

I would like to mail merge and keep the formatting (% $ amounts etc) from Excel like we could do with DDE. How do we do that with Microsoft 365?

[@mariemcdonald9285]

Hi Kevin, how do I attach this Mail Merge Letter to an email please? Marie

[@anitaclare2360]

My excel file has 9 worksheets that I need to reference in my email mail merge. How difficult is that to do?

[@mamdouhalsakhri2644]

Does it work with iPAD ?

[@hiesius3405]

Thanks bro, I love you

[@ruqiashah3653]

its great thank you soo much for this video

[@jennifercollins9573]

Hi Kevin - The videos are great. I am looking to use mail merge, using an excel file, but what I want to know is how to send a manager a letter listing several different accomplishments by one employee for team recognition. For example, send to manager, using employee full name and showing a list of items that the employee accomplished. I need the list of accomplishments to pull into the merge letter on different lines. How do I set up excel in order to pull in a list to mail merge? I have over 100 lines in excel, so I sort by manager name then by employee in order to sort and find the list of accomplishments. Some managers only have 1 employee with one accomplishment, so that is easy. There are some managers that have one employee that have accomplished five items.I am not sure how to pull in those five items into mail merge on separe lines. I hope that makes sense. Thak you.

[@giftynyahe6880]

Super helpful

[@CodyDaniels-zd2ie]

Hi Kevin thank you for ur explanations it helps me alot😊

[@hassanyousif7384]

Hi Can you create maintenance worksheet in excel ?

[@KevinStratvert]

can you tell me more about what you mean by a maintenance worksheet?

[@carlchristopher2534]

Yes you can. Just need to know to Column headings you want or need. Do you want it to just keep track of data (records) ??? Excel can do so much more. What is the end result(s) you want ???

[@anilkodakkadan]

You didn't mention how to send these letters through email. can we send email directly.

[@hectorruiz2544]

my microsoft word doesnt have the mailing options , can some one tell me how to find it please ?

[@ryanchandra5367]

awesome, can you do some excel videos

[@mpalanyianorld4975]

Thank you

[@susanpozey9409]

Hi Kevin: Can you use a Word table in lieu of Excel to do Mail Merge? Thanks.

[@TahaTazmeen]

Nice bro

[@muhindoimmaculate9513]

Thanks

[@Pitsomodiba]

I'm still struggling to do mail merge and I'm writing on 21May 2024

[@hdbzp2139]

my test starts in 40 seconds thnks

[@kuttipattu]

Always hood kevin

[@ruthwalden-turek1593]

Hey Kevin, I did this with a document that also has a table of contents, and it seemed to mess the table of contents up -- are you familiar with this? Is there a workaround?

[@debi9091]

Image content appears rather blurry.

[@debi9091]

Correction: I changed screen resolution option and that solved the problem.

[@ethiotech9161]

U R Special!

[@noorsk2348]

👍👍👍

[@justineramos1312]

2:19

[@judimcintosh436]

Speaks far too quickly to follow the information

[@pangding2662]

Emmmmmmm

[@pradnyakhobragade18]

You are distraction in your videos,,,you are too handsome 🤗

[@talented569]

tedious intro.

[@prosperityhlengo3009]

Thank you so much ❣🙏

[@tushay67]

you talk very fast

[@FastEnglish511]

❤