Forum Discussion
Send email when a column is not filled in excel online
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, ...
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.