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.
Contents
Download sample files
Contents
- Introduction – 00:00
- Prepare the data – 00:46
- Define data range name – 01:51
- Start Mail Merge in Word – 02:07
- Create email template – 02:35
- Add data – 02:57
- Preview Results – 03:33
- Run Mail Merge and send mails – 03:46
- Save as template – 04:35
- Mail Merge Rules – 04:41
- Record # Sequence # – 05:30
- If Then Else – 06:10
- Field codes – 06:53
- Fill In – 07:22
- Ask rule – 08:00
- Summary – 09:03
Related videos
Mail Merge Part 1 – Excel-Word-Email
Mail Merge Part 2 – CC and Attachments
Mail Merge Part 3 – Split data and email
2 Responses
Hi
I have been your student and a follower. I am facing an unique problem. when I get mail from couple of mail Ids , entire text message is getting delivered with words strike through
can you share your mail ID so that i can send you screen shot of the mail
It is not a problem with your mail app. It is the sender’s problem. Some CRM / marketing systems wrap emails in
…or…tags for diff‑tracking.Outlook reads it literally → everything becomes strikethrough. Or Some Android email apps place a
html tag.