使用Access 2016可以根据设备注册表中的预定服务日期发送电子邮件。 [英] Getting Access 2016 to send email based on scheduled servicing dates in an equipment register.

问题描述

您好，

我们使用Access 2016来管理我们工作的各个方面，并希望了解如何在2个月前自动将电子邮件发送给某些员工为各种设备提供服务。 我们只希望每件商品发送一次电子邮件
。 我们有一个'设备注册表'具有"下一个服务"的表格它将基于的字段，我可以添加一个包含员工/电子邮件地址的表。 我们使用Outlook作为我们的电子邮件系统。

We use Access 2016 for managing various aspects of our work, and would like to work out how to have emails automatically sent to certain staff members 2 months prior to servicing being due on various pieces of equipment.  We would only like the email to be sent once per item.  We have an 'equipment register" table with a "next service" field that it would be based around, and I can add a table with staff/email addresses.  We use Outlook as our email system.

任何帮助/建议都会很棒。

Any help/advise would be great.

非常感谢，

Rob

推荐答案

这真的是最好的主意吗？或者，拥有"即将到来的服务"会更好吗？表单或报告显示应用程序何时启动。然后每个人都可以看到每天即将发生的事情。另一个选择是使用Outlook
本身的提醒功能。

Is that really the best idea? Or would it be better to have a "upcoming service" form or report that shows when the application starts. Then everyone can see every day what is upcoming. Another alternative is to use the Reminder feature of Outlook itself.

假设你真的想要去电子邮件路线，接下来你需要的是查询和VBA的工作知识。如果你没有这个，你就可以雇佣必要的人才。

Assuming you really want to go the email route, the next thing you will need is working knowledge of queries and VBA. If you don't have that, you may have the hire the necessary talent.

这个代码将在你的应用程序启动时运行，并检查是否需要发送任何尚未发送的提醒已经送走了。然后它发送电子邮件（也许这是一个可以使用DoCmd.SendObject发送的简单报告）并更新一个他们已经发送
的表。此标志还需要在某个时刻再次清除（可能在维护完成后，将在下一个时间间隔再次触发。

This code would run at startup of your application and checks if any reminders need to be sent that have not yet been sent. It then sends the emails (maybe it's a simple report that can be sent using DoCmd.SendObject) and updates a table that they have been sent. This flag also needs to be cleared again at some point (maybe after the maintenance is done, so it will be triggered again at the next interval.

这篇关于使用Access 2016可以根据设备注册表中的预定服务日期发送电子邮件。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！