访问表格，以电子邮件完成到记录领域的电子邮件 [英] Access Form to email completion to email in field of record
问题描述
您好，
我正在使用一个数据库，我希望有一个非常简单的方法让人们通知他们已经完成了记录。让我更好地解释一下：
我的数据库有一个表和两个表单。第一种形式是请求更改的人，他们输入信息并单击保存。第二种形式是那些正在完成工作并将自己更新的人，然后也会保存。
我对Access很新，并做了一些事情但它有一些麻烦来完善工作。
我已经设置了第二个表单的保存按钮，打开一个包含记录PDF的电子邮件，但问题是我具有的是：To：字段需要具有来自记录中的一个字段的电子邮件地址。我似乎无法弄清楚如何做到这一点。
任何帮助将不胜感激。谢谢！
Hello,
I am working a database that I want to have a very easy way for people notify that they have completed a record. let me better explain:
My database has one table and two forms. The first form is for people requesting a change, they put in the information and click save. The second form is for those that are completing the work and will make updates of their own and then will save as well.
I am rather new to Access and have done a few things in it but having a some troubles refining the job.
I have set up for the second form''s save button to open an email with a PDF of the record but the problem I am having is that the To: field needs to have the email address from one of the fields in the record. I cant seem to figure out how to do that.
any help would be greatly appreciated. Thank you!
推荐答案
如果您使用DoCmd.SendObject方法，其中一个参数是To和To。电子邮件领域。如果您开始在VB编辑器中输入该方法，它将提示您输入所有参数。
您还可以使用命名参数（例如To：=" abc@mailserver.com" ;）。
希望这个hepps！
If you use the DoCmd.SendObject Method, one of the parameters is the "To" field of the E-Mail. If you start typing that method into your VB Editor, it will prompt you for all the parameters.
You can also use Named arguments (e.g. To:="abc@mailserver.com").
Hope this hepps!
我不知道VB编辑器是什么.......我正在改变保存按钮的属性，发现保存记录行上的宏构建器使我能够将对象的副本发送到电子邮件。我希望我可以告诉该命令使用它发送的同一记录的某个字段中的电子邮件地址。
I have no idea what the VB editor is.......I was changing the properties of the save button and found that the Macro builder on the save record line gave me the ability to send a copy of the object to an email. I was hoping that I could tell that command to use the email address that was in one of the fields of the same record that it was sending.
首先，请完全放弃Macros。我不能在这个论坛上列出一位不会推荐相同内容的专家。
而不是使用宏，在Event属性中选择[Event Procedure]，这将带您进入Visual Basic编辑器。
这对您来说可能是新的，但您会发现使用VB比使用宏可以做得更多。我们也愿意帮助您完成这项工作。
我们一直在为您服务。只是愿意学习并努力在这些方面提高自己的技能。还有很多VBA教程 - 不幸的是，这个论坛不是一个找到它们的地方。
常备协助。
First, please abandon Macros altogether. I can''t list a single expert on this forum who wouldn''t recommend the same thing.
Instead of using Macros, in the Event properties, select [Event Procedure], which will take you to the Visual Basic Editor.
This may be new to you, but you will find that you can do so much more with VB than with Macros. We are also willing to help walk you through this.
We''ve all been in your shoes. Just be willing to learn and seek to push yourself to greater skill in these areas. There are also plenty of VBA tutorials out there--unfortunately, this forum is not one such place to find them.
Standing by assist.
这篇关于访问表格，以电子邮件完成到记录领域的电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
