在Access 2007中发送问题 [英] eMail Problem in Access 2007
问题描述
我正在努力做同样的事情;我想在Access 2007中的表单上创建一个按钮，当单击该按钮时，在Outlook中打开一个新的电子邮件，只填写To：字段。我尝试了ADezii发布的代码（用我的字段名称替换[COMPANY_EMAIL] [GROUP_EMAIL_ADDRESS]）但是当我点击按钮时没有任何反应。
我是Access和VB的新手，所以我不确定代码中是否还有其他东西我需要更改以使其特定于我的数据库。任何有关这方面的帮助都将非常感激，因为我一直试图将这一个按钮想出两个星期。
I am trying to do the exact same thing; I want to create a button on my form in Access 2007 that, when clicked, opens a new email in Outlook with only the To: field filled in. I tried the code posted by ADezii (replacing [COMPANY_EMAIL] with the name of my field [GROUP_EMAIL_ADDRESS]) but nothing happens when I click the button.
I am completely new to Access and VB so I''m not sure if there is anything else in the code that I need to change to make it specific to my database. Any help on this would be greatly appreciated as I have been trying to figure this one button out for two weeks now.
推荐答案
这篇文章已从 Access中的超链接，输入掩码和发送电子邮件2007 ，可以找到任何相关或参考的代码。
肯德拉，
这显然不是同样的问题，否则你不需要进一步的帮助。如果你需要帮助，那么你需要创建自己的线程，而不是劫持别人的。
你可能想要更清楚地指明你希望从这个问题中得到什么。期待有人检查它是如何适合你的数据库的，这不太可能让你走得太远，因为这里没有人知道你的数据库。
我肯定你是否可以让你的要求清楚，然后有人可以帮助你。
欢迎来到 Bytes ！
This post has been moved from Hyperlinks, input masks, and sending email in Access 2007, where any relevant or referenced code may be found.
Kendra,
This clearly isn''t exactly the same problem, otherwise you wouldn''t require further help. If you need help, then you need to create your own thread and not hijack someone else''s.
You may want to specify more clearly exactly what you hope to receive from this question. Expecting someone to check how it fits your database is not likely to get you very far as no-one here knows anything about your database.
I''m sure if you can make your requirement clear then someone can probably help you.
Welcome to Bytes!
对不起，我从未尝试过之前在论坛上获得帮助。
我在Access 2007中创建了一个数据库，用于我公司工作的所有社区组。从这个数据库中，我创建了一个表单，使其他人更容易查看和更改记录。我注意到，当有人想要通过电子邮件发送其中一个组时，他们必须从表单中复制电子邮件地址并将其粘贴到Outlook中的新邮件中。
我希望通过创建一个用户可以点击的按钮来简化此过程，这将自动打开一个新的电子邮件窗口，其中To：字段根据用户的记录预先填充正在观看。
Sorry I''ve never tried getting help on a forum before.
I have created a database in Access 2007 of all the community groups with which my company works. From this database, I created a form to make it a bit easier for others to view and change records. I''ve noticed that when anyone wants to email one of these groups, they have to copy the email address from the form and paste it into a new message in Outlook.
I want to make this process easier by creating a button users can click on which will automatically open up a new email window with the To: field pre-populated based on the record the user was viewing.
@KendraAsh
将此简单命令放在按钮的单击事件中。然后，您可以将该表单文本框的内容传递给变量myemail，而后者又由FollowHyperlink命令用于打开电子邮件。电子邮件地址根据您的需要放置在邮件窗口的收件人：部分。
@KendraAsh
Place this simple command in the on click event of your button. You can then pass the contents of that form textbox to the variable myemail, which in turn is used by the FollowHyperlink command to open an email message. The email address is placed in To: section of the mail window as you require.
这篇关于在Access 2007中发送问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
