Generate emails from Excel?

Copper Contributor

Hello all,

 

I was hoping somebody out there might be able to offer some suggestions for a work-related function.

 

Un a nutshell; I work in a school, and one of

my duties is to fill out the weekly detention log in Excel and email notifications to the students.

 

Obviously, this can be a very time-consuming task, especially if my other duties  require more of my attention, so I was wondering there’s any way I can auto generate the email notifications (in outlook) from the data entered in Excel and save the emails as drafts without sending them?

 

(That last part about not sending the emails is very important, as I still want to review emails and add the recipients’ addresses manually for obvious data protection concerns)

 

Is what I’m thinking here possible?

 

Thanks in advance

 

 

1 Reply

@Kmadden2004 

In this link you will find various options and examples of mail with Excel.

Mail from Excel

none Microsoft site