MS Access：将验证字段添加到已通过电子邮件发送的记录中？(MS Access: Adding a verification field to records that have been emailed?)

 我的MS Access数据库中内置了电子邮件功能，它根据等于今天的日期的时间戳查询添加的所有记录，并将它们添加到通过电子邮件发送的报告中。 这不是自动的，因为不是每天都有记录进入它，而是用户触发 - 通常是在一天结束时。 
 
 但是如果有人忘了呢？ 
 
 查询可以被重写以过滤>=Date()-1 （或者多天）的时间戳，但是我们确实不希望多次发送相同的记录。 有没有办法在查询运行时发送电子邮件时，它会标记发送的记录以便它们不再发送？ 

I have email functionality built into my MS Access database that queries all records added based on a timestamp that equals today's date and adds them to a report which is emailed. This is not automated, as not every day has record entered into it, but user triggered - usually at the end of the day.
 
But what if someone forgets?
 
The query could be rewritten to filter the timestamp for >=Date()-1 (or however many days), but we really don't want to send the same record more than once. Is there a way that, when the query runs to send the email, it marks the records that are sent so they aren't sent again?

原文：https://stackoverflow.com/questions/43002275