Forum Discussion

srinishine's avatar
srinishine
Copper Contributor
Jul 06, 2022
Solved

How to send a customized email for a list of individuals

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,

Resources