有权访问发送电子邮件，电子邮件自动化 [英] having access send an email, email automation

问题描述

是否可以根据条件生成自动电子邮件？

例如，一旦记录达到特定年龄，就会自动填写电子邮件并发送到电子邮件中收件人。

is it possible to have access generate an automatic email based on a condition?
say for example, once a record reaches a particular age, have an email automatically populate and send to the email of the recipient.

推荐答案

二合一。


Q1。 Access可以代表您发送电子邮件吗？

A1。是的，但非常合格的是。由于电子邮件系统上的限制数量提供了一定程度的安全性，许多发送电子邮件的尝试都会自动失败，或需要操作员干预（不方便）。


使用Outlook处理在各种线程中所以我不会在这里重复任何一个。可以说，除了Outlook所采用的限制之外，还有一些限制可能存在（例如，对SMTP的IP限制）。


Q2。是否可以在Access中安排？

A2。技术上没有。但是，在查找可以触发某些代码的内容时，Access可以针对特定条件进行轮询。也可以从操作系统和该数据库安排Access（甚至是特定数据库）的运行，以自动运行启动代码。


这只能用作但是轮询方法，因为调度程序将无法识别触发执行的任何特定于Access的条件。


希望这会有所帮助。

Two in one.

Q1. Can Access send e-mails on your behalf?
A1. Yes, but a very much qualified Yes. Due to the number of restrictions placed on email systems to provide a level of security, many attempts at sending emails automatically fail, or require operator intervention (Not convenient).

Using Outlook is handled in various threads so I won''t repeat any of it here. Suffice to say there are also restrictions that may be placed on this over and above those applied by Outlook (IP restrictions on SMTP for instance).


Q2. Is it possible to schedule within Access?
A2. Technically no. However, it is possible for Access to poll for a particular condition, upon finding which it can trigger some code. It is also possible to schedule the running of Access (or even a particular database) from the operating system and for that database to run startup code automatically.

This can only be used as a polling method though, as the scheduler will not recognise any Access specific conditions upon which to trigger execution.


Hope this helps.

@NeoPa


是的，它确实非常有用。

我从这个董事会那里了解到更多其他人



谢谢！

@NeoPa

yes it does help very much.
ive learned more from this board that any of the others


thanks!

您访问其他板！休克！恐怖！


开玩笑吧。我们非常乐意帮助Trixx。

You visit other boards! Shock! Horror!

Just kidding. We''re very pleased to help where we can Trixx.

这篇关于有权访问发送电子邮件，电子邮件自动化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！