使用表数据自动邮件传递时间

本文介绍了使用表数据自动邮件传递时间的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

美好的一天， 我有一个访问数据库 我希望能够每3个月向自己发送一封提醒邮件 因此，今天日期与我表格中的上次更新日期相关的基础知识> 30 然后自动发送电子邮件 目前我正在使用延期交货时间方法.. 但我更喜欢一种计算方法我的表格中今天日期与上次更新日期之间的差异以及是否> 30。 然后今天的日期作为延期交货时间的参数传递 谢谢

Good Day, I have an access database I want to be able to send a reminder email to myself every 3 months So basicall when today date vs last update date in my table > 30 Then automically send email At the moment i am using the deferred delivery time method.. But i would prefer a way to calculate the difference between todays date vs last update date in my table and if >30. Then today''s date is passed a s the parameter for the deferred delivery time Thanks

推荐答案

那么，你有什么了？ 你想要什么帮助？ 如果与运行代码的日期相同，为什么要设置延期日期？ 这里有一个问题，但是它不是很清楚。我似乎记得你已经删除了一些/你已经提出更多意义的指示，所以我猜这是你能做的最好的。我们善于诚实的尝试，但你需要回答这三个问题，以便我们帮助你制定一个我们可以帮助的明智的问题。 So, what have you got already? What do you want help with? Why would you want to set a deferred date if that is the same date as you run the code? There''s a hint of a question here but it''s not very clear. I seem to recall deleting a/some questions from you already with instructions to make more sense, so I''m guessing this is the best you can do. We''re good with honest attempts, but you need to answer these three questions to allow us to help you formulate a sensible question that we can help with.

感谢你的回复NeoPa 拥有自定义日期的主要目的是我希望每3个月生成一次提醒电子邮件，而不会提醒我更新我的数据库部分 什么我真的很想 修改日期与我运行代码的日期不同 代码将持续每天运行 但是我是什么真正想要的是，我设定了一个日期作为基准，并且30天的时间告诉了benchamrk日期，提醒邮件发送给我。然后benchamrk日期被重新设置并设置为发送emial的那天以及另外30天的倒计时开始。 我尝试使用deffered传递方法并且从现在起30天开始但是这个剂量工作，因为这意味着我将不得不继续返回并再次编辑延迟交货时间到接下来的30天，这完全击败了自动化的全部目的 如果我之前的帖子不是很好，我很抱歉可以理解 感谢您的帮助 Thanks for the reply NeoPa The main aim of having a deffered date is that i want a reminder email to be generated every 3 months without any inut from me to remind to update sections of my database What i really wan The deffered date is not the same date i run the code The code is going to run continually everyday But what i really want is that that i set a date as a benchmark and 30 days adter that benchamrk date, the reminder mail is sent out to me. and then the benchamrk date is refereshed and set to the day the emial was sent out and another 30 days countdown begins. I tried using the deffered delivery method and just settin ti 30 days from now but this dosent work because it would mean that i would have to continoulsy go back and edit the deferred delivery time again to the next 30 days which totallydefeats the whole purpose of automation I am sorry if my earlier post was not very understandable Thanks for all your help

Elak，当您的问题没有意义时，通常是因为您不专注于问题很清楚。在这种情况下，如果能够更清晰地思考的人发布了一些问题供您回答，通常会有所帮助，因为这些问题的答案通常会澄清问题（实际上，问题是专门为此目的选择的）。这使得您尽可能地回答这些问题非常重要。没有回答问题的进一步解释，坦率地说不太可能有很大的帮助（就像在这种情况下一样），就像你能够清楚地解释它一样，人们会认为你原本已经做过了。 我建议那么，在阅读这篇文章后回答问题将是你做的第一件事。 有更多的事情要考虑，但没有那个基本问题排序出于我的解释，我怀疑是没有意义的。 Elak, when your question doesn''t make sense it''s often because you don''t focus on the problem very clearly. In that case, it often helps if someone, who is able to think more clearly, posts some questions for you to answer, as the answers to those questions often clarify the question (Indeed, the questions are chosen specifically for that purpose). That makes it very important that you answer those questions as well as you can. Further explanations without the questions answered, is frankly not very likely to be of much help (As in this case) as if you were able to explain it clearly one would assume you''d have done it originally. I suggest then, answering the questions would be the first thing you do after reading this post. There are more things to consider, but without that basic question sorted out my explanations will make little sense I suspect.