如何通过Outlook 2007电子邮件发送自动生日警告？ [英] How to send an automatic birthday warning by Outlook 2007 e-mail?

问题描述

我是DB新手，我必须使用Access 2007，在公司，我们有一个数据库，其中包含一个包含员工信息的表，如DOB，我会喜欢在3到5天之前向主管发送一封自动电子邮件，让主管发送生日贺卡。

我该怎么做？我认为它可以使用自动宏或类似功能自动完成。

你能帮我吗？请不要忘记我对DB很新。我非常了解VBA for Excel和Excel，但这必须与Access一起使用。

提前谢谢

Hi,
I am new to DB and I have to use Access 2007, at the company, we have a database with a table that has employee''s information such as DOB, I would like to send an automatic e-mail to their supervisor 3 to 5 days before to let the supervisor send a Birthday card.
How can I do that?? I think it can be done automatically using auto macro or similar.
Can you help me?? Please do not forget I am fairly new to DB. I know VBA for Excel and Excel very well, but this has to work with Access.
Thank you in advance

推荐答案

嘿，和欢迎来到 Bytes


我确定有几种方法可以做到这一点，但我想到的方法是使用一个简单的表格定时器连接（定时器调整为每24小时运行一次）。访问表单中的计时器基本上是运行代码的触发器。


然后您可以将代码附加到计时器事件，该事件检查表以查看是否会在5天后发生任何生日现在，然后发送电子邮件。我还没有真正处理从访问中发送电子邮件，但有几个关于该特定部分的好帖子。


我或其他人可能会详细介绍其中的一些步骤，如果你需要。

Hey, and welcome to Bytes

Im sure there are several ways to do this, but the approach that springs to mind for me, is to have a simple form with a timer attached (Timer adjusted to run every 24 hours). The timer in an access form is basicly a trigger for running code.

You can then attach code to the timer event, which checks a table to see if any birthdays will occur 5 days from now, and then send an email. I haven''t really worked with sending emails from access, but there are several good posts about that specific part.

I or someone else can probably detail some of the steps more, if you need.

由于问题的范围很广泛，我建议我们在这里只讨论触发流程的概念，这个概念可能会通过电子邮件处理发送消息，给相关的主管。发送电子邮件，你可以单独询问（或搜索解决方案，因为这个网站上已经有很多这样的解决方案）。


笑脸的建议是可行的，但确实如此依赖数据库在所有/大部分时间在某个地方运行。另一种方法是让数据库在启动时运行检查，查询显示接下来三天内即将到来的所有生日。如果找到任何一个，那么可以触发该过程并触发所有相关主管的任何事情。这种方法依赖于数据库每天至少运行一次。

As the question is unfortunately so broad in scope, I suggest we deal here only with the concept of triggering the process, which will deal with sending a message, probably via email, to the relevant supervisor. Sending an email you can ask about separately (or search for solutions as there are already so many of them available on this site alone).

Smiley''s suggestion is workable, but does rely on the database to be running somewhere all/most of the time. An alternative is for a database to run a check on startup, of a query that displays all birthdays approaching within the next three days. If any are found then the process can be triggered and fire off whatever to all relevant supervisors. This approach would rely on the database being run at least once daily.

我之前已经完成了Outlook的自动化，你需要注意一些事情。如果您尝试访问Outlook以发送电子邮件，它将提示您，您必须等待5秒才能单击提示，它将询问您希望多长时间访问Outlook。


如果这是不可接受的，你将不得不使用其他一些第三方.dll来完成它。

I''ve done automation of Outlook before and there''s something you need to be aware of. If you try to access outlook to send e-mail, it will prompt you, you must wait 5 seconds before you can click the prompt, and it will ask you how long you want to give access to outlook.

If that is not acceptable, you will have to use some other third-party .dll to get it done.

这篇关于如何通过Outlook 2007电子邮件发送自动生日警告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！