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