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.
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
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.
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?
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
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
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 #
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?
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
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!
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.
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!
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.
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 🙏
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
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.
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 ???
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?
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
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.
Thank you Kelvin for sharing your ideas with us, I have just made my first mail merge successfully, am so happy right now💕💕💕💕💕
Thank you very much to this man, he made me understand mailmerge better than my school teacher does
THANK YOU VERY MUCH KEVIN, THE training on mail Merge is wonderful. Thank you
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
Thanks a lot for this helpful video! I have just done my letters 😊
Lifesaver, up to the point. Thank you
This was so helpful to me today! So easy to understand. Thank you!
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.
Thank you so much. This was very helpful and straightforward.
I like this tutorial,I really need this for our school activity. Thank you
Whoa.. I'm also here because of School. LOL
Thanks. I don't do this often, so a uick refresher course was VERY helpful.
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?
thank you. This was really well explained!
Hi Kevin, your video tutorials are extremely helpful. Please post tutorial on Quick Parts & Building Blocks in MS Word. Thank you.
This was super helpful! I haven't done this in a year so it was a great refresher.
Thank you 🙏 I just want to be learning something about tech each day of my life
I would like to see how to email from a list in an Excel spreadsheet.
Thank you a lot this really helped me out for my SBA👍
Thank you Kevin, I expect to learn more watching your other videos, so I have subscribed
This was extremely helpful,
Can you please do a video explaining amortisation in excel that has changes in inerest rate
Great Stuff Kevin, Thank you
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.
How can i merge fraction? Looks fine in database but doesn't convert in my letter
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
Pls advise how to use mail merge for Bulk email in Outlook 365?
I dont have Mailings tab on my word online version
Nice video, thank you so much!
Thank you once again ... Have learnt so much from your tutorials 👌
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
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?
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
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 #
im doing chapter 5 for ms word and it does not want to merge the letter into an evelope? i need help please
Hi Kevin the tutorial is very helpful
Hi. Why can’t I see the set up wizard as an option from the drop-down? I’m in 365 using Mac.
HI if i only use the online version of M 365 and i want to use merge. Wish solution are the best!?
Can we do mail merge in word 2007?
my microsoft word doesnt have the mailing options , can some one tell me how to find it please ?
Hey. Thank you. How can I print each letter as separate pdf?
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?
How can I save the different letters separately?
Not 1 file having say 50 letters but 50 different files.
Hey, can you mail merge from another platform into Word, such a table within Notion?
Why cant you insert a signature line created by the add on Draw?
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?
Can we send mail merge with personalized CC or BCC? Without adds in?
Can We Print the pdf individually but at once like for maybe 50 names?* (50 individual for 50 pdf for example)
Did you find out the way?
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
Hey Carl- this video will show you how to send attachments with mail merge: ua-cam.com/video/yj_s3cdfVDY/v-deo.html
Good videos , however i still can not see how to change the content off the letter. Eg a Different framework of aggreement
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!
Do we have any solution for this issue ?
Is there a way to do this when the certificate is in power point instead of word?
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.
You didn't mention how to send these letters through email. can we send email directly.
Great video!
headers and Footers don't appear after mail merge
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!
How do you set a timer so all emails dont send at once?
Thank you ! I needed this for work !
I like this guy intro, great tutorial
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.
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?
Can you do this with emails?
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 🙏
Hi Kevin, how do I attach this Mail Merge Letter to an email please? Marie
Thanks bro, I love you
Looks like an epic climb! I'm going to guess Squamish!
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
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.
Thank you so much bro
Hi Kevin,
Is there a way to Mail Merge a letter from two difference worksheets?
its great thank you soo much for this video
My excel file has 9 worksheets that I need to reference in my email mail merge. How difficult is that to do?
Hi Kevin thank you for ur explanations it helps me alot😊
Thank you!
Thank you so much. I just follow your video, it helps me a lot for my project. Thank you. God bless.
Formatting in mail merge of labels.
Super helpful
Hi
Can you create maintenance worksheet in excel ?
can you tell me more about what you mean by a maintenance worksheet?
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 ???
Does it work with iPAD ?
awesome, can you do some excel videos
Thank you
I'm still struggling to do mail merge and I'm writing on 21May 2024
Hi Kevin: Can you use a Word table in lieu of Excel to do Mail Merge? Thanks.
Nice bro
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?
Always hood kevin
Thanks
my test starts in 40 seconds
thnks
Image content appears rather blurry.
Correction: I changed screen resolution option and that solved the problem.
U R Special!
👍👍👍
Speaks far too quickly to follow the information
2:19
Emmmmmmm
You are distraction in your videos,,,you are too handsome 🤗
tedious intro.
Thank you so much ❣🙏
you talk very fast
❤