Hi
I have a Command Button in my Database that when pressed runs a macro that runs a set of queries and then a number of automated emails to different recipients based on the results of the queries.
With a team of only a few people that perform this action, you would think that we would be able to communicate with eachother to let eachother know when we have sent the emails out. Unfortunately not.
I have suggested that as part of the action, the macro could also send an email to the members of my team informing them that the emails had been sent out, but they said that as the emails need to be sent out first thing, they usually open the Database as soon as they get in, before checking their emails.
Can anyone think of another way of letting the user know the action has been performed when they open the Database?
I thought about disabling the button for 24 hours after it had been pressed, but there could be a valid reason why the emails would need to be sent again and I'm not sure if that is even possible.
I have a Command Button in my Database that when pressed runs a macro that runs a set of queries and then a number of automated emails to different recipients based on the results of the queries.
With a team of only a few people that perform this action, you would think that we would be able to communicate with eachother to let eachother know when we have sent the emails out. Unfortunately not.
I have suggested that as part of the action, the macro could also send an email to the members of my team informing them that the emails had been sent out, but they said that as the emails need to be sent out first thing, they usually open the Database as soon as they get in, before checking their emails.
Can anyone think of another way of letting the user know the action has been performed when they open the Database?
I thought about disabling the button for 24 hours after it had been pressed, but there could be a valid reason why the emails would need to be sent again and I'm not sure if that is even possible.