Hi. I'm hoping you can help.
Feel free to suggest entirely different solutions. I'm trying to implement a system that automatically emails users if the due date of their tasks has elapsed.
My current thoughts are to add code to the dashboard form onload event that checks for expired tasks and sends the emails (and then records that they've been sent so the process doesn't keep repeating). However this has a problem in that it means the emails would be sent from the email account of whoever happened to open the database at the opportune time. This could confuse the receivers in that the email could appear to come from someone completely unrelated to the task and upset the people whose outlook accounts I'm taking change of.
I don't have a dedicated database email address and I doubt I could convince work to allow me to set one up (though I could try). I don't want to restrict it to only work if it's be that loads the database (I'm the whole design team) due to holidays etc. What I see as ideal would be a way to hide the sender of the email so the receiver can't see it and can't reply to the email. Is there anyway to do this? Can anyone think of any other workable solutions? Worst case I'll roll with it and put a big warning at the start of the email but I'm not happy with that. Any help would be appreciated.
Thanks. Robyn