How to send a customized email for a list of individuals

[srinishine]

Hi,

I have a list of students with their ID numbers in an excel sheet. I want to send a seperate email to each student with the respective number. Is there a way to auto generate this email (the red text highlighte din the below email body is ectracted from the Excel sheet) for each participants and send it in Outlook windows desktop app?

Sample table

Name--- StudentEmail--- ID

Alex --- email address removed for privacy reasons --- 112A

Brenda --- email address removed for privacy reasons --- 115K

Jake --- email address removed for privacy reasons --- 234X

The email I want to send is as follows;

Dear Alex,

Thank you for registering with us. Your Id is 112A.

Best regards,

[#2 · Accepted solution]

@srinishine 

I found this article that can guide you in the right direction.  
5 Simple Steps to Send Mass Email in Outlook (2022) | Sendinblue

If you find this information help, please like it.

Have a good day!

/Teresa

#traccreations4e

. 

[#3]

Thank you very much. This worked!