Mail Merge Made Easy: From Excel to Word to Outlook

[@JenniferLCornell]

Jamie--you just saved me hours with the mail merge video instructions! I would have spent hours emailing all of my customers today (asking about their holiday hours) versus a five minute process (once I had them in an excel sheet). Your instructions were so clear and comprehensive. Thank you!!!

[@TeachersTech]

You are very welcome!

[@melissaannboone3639]

I've been using this for decades. I can't believe ALL teachers don't know this. Great video!

[@TeachersTech]

Glad it was helpful!

[@mielcaru8675]

I have watched so many videos tyring to understand Mailmerge and I finally understood after your video. I am so grateful for your video. thank you!

[@HSsenpai26]

This was amazing! Thank you so much!

[@TeachersTech]

You're welcome! I'm happy it helped.

[@tpcomcam]

Most useful - I was having difficulty with emailing to "groups" in the new Outlook. This looks like a much better way to do it. Thank you. David

[@TeachersTech]

You’re welcome!

[@jessica27596]

Thanks You ! I learned a lot from you videos.

[@HRISCentobiea]

Thank you!! Excellent tutorial!

[@TeachersTech]

You’re welcome! Glad you liked it.

[@KhalidMahida]

Great, very helpful. Thank you so much for your contribution.

[@jackie81]

Thank you so much this was super helpful!!

[@joannneri9722]

Great tutorial. Can this also be done in Google Docs?

[@amyvilla9902]

Hi, I’ve used the merge that you reviewed and had success with the email. If I want to save each document separately on my desktop, do I need to download a document splitter? For example, student progress reports. I email them to each family, but also want to save each one as a separate document. Thanks for your videos.

[@fiorentedesignshg9852]

Great video and helpful tutorial. Question: is there a method for attaching individual pdf tailored for each recipient? Thank you. N.B., I’ve subscribed to your channel and I’m looking forward to your videos. :)

[@TeachersTech]

Thanks! I was going to create another video about dealing with attachments.

[@fiorentedesignshg9852]

Timing is everything, as they say ;) I’m striving to find a solve for unique attachments with mail merge … today. May have to resort to manual emails with each attachment one last time and await your new video on this topic. Thanks for your swift reply! Cheers.

[@topeosho1]

Great video. Quick question please, how do I check which outlook email account is linked to the Word document? I've tried email the merged document but it's not showing in any of my Outlook 'Sent' boxes. Thanks!

[@palashhaldar1605]

After completing all the process marge field also reflected but mail is not send to mail address or not send from my Outlook

[@TeachersTech]

That's strange, were you using the practice files I provided or were they different ones?

[@tess2hearts124]

I double checked my list, and went through again, nope my outlook never sent etc… frustrating… I’m gonna give it rest

[@MrKlawUK]

can this work with a dynamic excel? eg if that first sheet neesd to be filtered to show a different list of contacts, does it create any complications?

[@manuelduran139]

I would like to know if i need to attach a document in the mails, how can i do that??

[@okNerdRage]

How would I keep it from adding extra line items when I have multiple fields to add across the database? For instance I have taxes, prices, totals, but all vary per document, my problem is that all of the fields that I add, even if they're blank, they add a break and even though there's no data there I end up with a 3 page document of blank space rather than just populating the specific fields when there is data present. Is there a way to optimize this?

[@LEENA-jv2sz]

Can we also check the campaign performance? If yes, how?

[@miskittt]

Thank you!!!

[@bumble_beeast_3929]

Is it possible to Exclude contacts on a Excel list or would i have to create a new Excel Sheet that does not include the email?

[@neyoriquans7782]

In your word document, if you go to the Mailings header, and find the option that says "Edit Recipient List", you should be able to uncheck the checkboxes for the people you don't want to send an email to.

[@lnwmelon]

How would you format the “Today’s date” line?

[@michaelgrundy956]

How would you delay delivery of these emails? I am going to send out students' grades and I want to be off the school premises by the time they receive their results!

[@Niptittude]

What if I need to combine a mr and ms from separate rows in the spreadsheet to the same letter? The common denominator between them On the spreadsheet is the same letter reference code.

[@gmostafaali]

Hi, is there limited users, need subscription for more users to send email or free for unlimited?

[@claudettea]

I want to mail merge parents with results of student's, however, I'm having trouble with the percentage column. eg. 60% How can you mail merge results?

[@nitetimejohnson]

Thx

[@李家李]

Hi techer, good but can you help me why i couldn’t send out via my web outlook365? Even I switched my outlook 365 to windows base but still in vain. Could you pls help on this.

[@manjularathnayake-d5g]

my emails are not sent. any comments appreciated.

[@neyoriquans7782]

Same issue, no luck so far

[@ellenpalmer8571]

Well, I like your easy to understand teaching………here’s my problem……….why can’t i find MY Excel document headings?????????? I’m only seeing the preset headings in Word………I even tried to use their F1, F2, F3, etc and got nothing but blank documents. Windows 7 used to let me see my document headings!!!! Now I have 365 and am going to scream…………I hope you can help me before the top of my head pops off!!!!!!

[@harrytaylor6318]

This has prevented me from kms