Access 2007中的超链接，输入掩码和发送电子邮件 [英] Hyperlinks, input masks, and sending email in Access 2007

问题描述

我一直试图解决这个问题三个星期。我一直在睡觉。没有得到答案，只是失眠。 ;-)


在表格中，我有一个字段COMPANY_EMAIL。在此字段中，我希望最多允许8个字符，始终使用相同的域，并且在表单中可以单击并打开发送给该客户的电子邮件。我已经通过多种方式尝试过这种方式，我认为它最终发生在我身上，我无法在一个地方做任何事情。我想我可能需要一个按钮。


我正在使用< aaaaaaaa！" @ domain"。" com"在我的输入掩码中。这是非常好的，除非地址只有4个字母，它在左侧留下4个空格。我不喜欢那样。想法？


我在表单中的电子邮件字段旁边放了一个按钮（而不是尝试使用超链接和输入掩码......让我无处可去快的）。现在按钮就在那里。我知道我需要一些可能在点击后面的代码。但我不知道该放什么来打开指定地址的电子邮件。想法？


我知道mailto：part ...我试图在输入掩码中使用一个字段作为带有mailto：和domain.com的超链接（结束使用mailto：[e-mail]），但有时，例如，如果地址是[e-mail]，则m表示m。将取代m在mailto：和bo中将作为电子邮件地址进入。当我选择一个正确输入并在表单中点击它的地址时，它永远不会打开电子邮件...所以我正在尝试提出一个新计划......就像上面的按钮计划一样。


我需要你的指导/想法，所以扔一些给我！

非常感谢你的时间，耐心和大脑！ ： - ）

I''ve been trying to figure this out for three weeks. I''ve been sleeping on it. Not getting answers, just losing sleep. ;-)

In a table, I have a field COMPANY_EMAIL. In this field I want to allow up to 8 characters, use the same domain always, and in a form be able to click and open an email to this customer. I have tried this in numerous ways, and I think it''s occuring to me finally I can''t do everything in one place. I think I might need a button.

I''m using <aaaaaaaa!"@domain"."com" in my input mask. This is pretty good, except if the address is only 4 letters, it leaves 4 spaces on the left side. I don''t like that. Ideas?

I have put a button next to the email field in the form (as opposed to trying to use a hyperlink and an input mask...that got me nowhere fast). Right now the button is just sitting there. I know I''ll need some code probably behind "on click" but I don''t know what to put there to open an email to the address specified. Ideas??

I''m aware of the mailto: part...I tried to use one field as a hyperlink with the mailto: and domain.com all in the input mask (to end up with mailto:[e-mail]) but sometimes, say for instance if the address was [e-mail], the "m" would replace the "m" in mailto: and the "bo" would go in as the email address. When I chose an address that would go in correctly and clicked it in the form, it would never open an email anyway...so I''m trying to come up with a new plan...like the button plan above.

I need your guidance/ideas, so throw some at me!!!
Thank you so much for your time, patience, and brains! :-)

推荐答案

我从应用程序发送邮件时不太热。每当我尝试它时，副作用就会让我失望。有一大堆线程（其中一些我参与其中）处理安全问题等等。


话虽如此，我当然可以帮助界面以及如何组成，甚至存储电子邮件地址。


让我们从一个问题开始。你真的想要@blah blah.com吗？要由操作员输入和/或保存？我会考虑将它包含在Label控件中的表单上，并且只是处理界面中的名称部分。

I''m not too hot on mailing from an application. Whenever I tried it the side issues put me off. There are a whole bunch of threads (some in which I''m involved) which deal with security problems etc etc.

Having said that, I can certainly help with the interface and how to make up, and even store, the email addresses.

Let''s start with a question. Do you really want the "@blah blah.com" bit to be entered by the operator and/or saved? I would consider including that as static on the form in a Label control and just dealing with the name part in the interface.

我可以确定地说服某种方式。你看，我正在做我在Access上可以理解的事情......我还不熟悉所有其他的，更好的方法可以做到。我在BYTES学到了很多东西。事实上，BYTES可能使这个项目取得了成功，而不是让我失败。

所以，您似乎鼓励我只处理电子邮件地址的第一部分。我可以走那条路，我只需要一些关于如何连接@ domain.com的指导。使用数据库的人对计算机的了解远不如我，所以我希望他们能够轻松地向客户打开电子邮件。说服我朝着一个方向......到目前为止，你的建议一直是现象。 ： - ）

I could definetely be convinced to go one way or the other. You see, I am just doing what I can comprehend on Access...I''m not yet familiar with all the other, better ways things can be done. I''m learning A LOT here on BYTES. In fact, BYTES has probably made this project a success instead of a failure for me.
So, it seems you encourage me to just deal with the first part of the email address. I can go that route, I''ll just need some guidance on how to get the @domain.com connected. The people that will be using the DB are far less computer savvy than I am, so I wanted to make it easy for them to open an email to the customer. Persuade me in a direction...your advice so far has been phenominal. :-)

@DanicaDear


Danica，你的电子邮件客户端是什么（Outlook ，Internet Explorer等）？

@DanicaDear
Danica, what is your E-Mail Client (Outlook, Internet Explorer, etc.)?

这篇关于Access 2007中的超链接，输入掩码和发送电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！