Learn how to get data from Excel and send a mail to each row of data.
This uses Word to create the template and Outlook to send the mail.
This will work on Windows with Desktop apps of Word and Outlook.

Download sample files:
https://efficiency365.com/wp-content/...

Contents 📚
00:00 - Introduction
00:46 - Prepare the data
01:51 - Define data range name
02:07 - Start Mail Merge in Word
02:35 - Create email template
02:57 - Add data
03:33 - Preview Results
03:46 - Run Mail Merge and send mails
04:35 - Save as template
04:41 - Mail Merge Rules
05:30 - Record # Sequence #
06:10 - If Then Else
06:53 - Field codes
07:22 - Fill In
08:00 - Ask rule
09:03 - Summary

Related videos
Mail Merge Part 1 - Excel-Word-Email -    • Mail Merge Part 1 - Excel data - Word...  
Mail Merge Part 2 - CC and Attachments -    • Mail Merge Part 2 - CCs and attachment  
Mail Merge Part 3 - Split data and email -    • Mail Merge Part 3 - Filter and send E...  

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn :   / nitinparanjape  
Twitter :   / drnitinp  

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)