Send email when a column is not filled in excel online

[AnunaySingh]

Hi Everyone, 

I have a situation and I need help for it. 

I have a table which has few columns

1) Name,

2) email address,

3) Status &

4) Date

So my requirement is basically two fold,

1) I have to check for only blank rows in the "Status" column

2) If a blank row is encountered in Status column against any name, Email address then I have to trigger an email with a text message to the user of that row.

I am using Excel-online for this. 

Help highly appreciated 

[#2]

@AnunaySingh 

You can work with an auxiliary column and the function =HYPERLINK(). There you can also include a subject and the mail content in the function.

Enclosed is an example document.

However, you would have to send each mail by clicking on the hyperlink and then clicking on send in your mail programme.

If you have a lot of data, it would be easier to create a serial email in Word and then send it with Outlook. However, this does not work with the web version of Word.

[#3]

You can follow this tutorial and use Office Scripts and Power Automate to implement this solution: https://docs.microsoft.com/en-us/office/dev/scripts/resources/scenarios/task-reminders