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