使电子邮件字段中的条目成为一个超链接,以便在Outlook中发送电子邮件 [英] making the entries in e-mail field a hyperlink to send an e-mail in outlook

查看:329
本文介绍了使电子邮件字段中的条目成为一个超链接,以便在Outlook中发送电子邮件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我搜索了论坛和帮助,但仍然非常困惑。


我有一个简单的表格,其中一个字段是电子邮件。

我有一张桌子上的simle表格。


联系人的电子邮件出现的地方(表格或表格中)我希望Access给我看一个超链接,当我点击它时,它会打开一个新邮件到该电子邮件地址。类似于MSWord和大多数其他办公程序中的超链接电子邮件地址。


更好的是在表单上添加一个发送电子邮件给的按钮这个人


请帮忙。

谢谢

解决方案

< blockquote class =post_quotes>
我搜索了论坛和帮助,我仍然很困惑。


我有一个简单的表格,其中一个字段是电子邮件。

我有一张桌子上的simle表格。


联系人的电子邮件出现的地方(表格或表格中) )我希望Access向我显示一个超链接,当我点击它时,它会打开一个新邮件到该电子邮件地址。类似于MSWord和大多数其他办公程序中的超链接电子邮件地址。



在包含电子邮件字段的表格中,将字段数据类型设置为超链接。


Mary



在包含电子邮件字段的表格中,将字段数据类型设置为超链接。


Mary



我试过了,但这打开了电子邮件地址。在Internet Explorer中,认为这是一个Web地址!即如果我输入一个可以正常使用的网址,但是在电子邮件地址被转发到电子邮件程序的意义上它不起作用!



我试过了,但这打开了电子邮件地址。在Internet Explorer中,认为这是一个Web地址!也就是说,如果我输入一个可以正常使用的网址,但是在将电子邮件地址转发到电子邮件程序的意义上它并不起作用!



暂时将字段更改回文本。然后运行find并将所有 http:// 替换为 mailto:


然后再次更改为超链接。 />

添加新的电子邮件地址时,请在每个地址的开头添加mailto:

Mary


I have searched the forum and the help and am still very confused.

I have a simple table with one of the fields e-mail.
I have a simle form for that table.

Where the contact''s e-mail comes up, (either in the form or the table) I would like Access to show me a hyperlink that when I click on it, it opens a new message to that e-mail address. Similar to when you have a hyperlinked e-mail address in MSWord and most other office programs.

Even nicer would be to add a button on the form saying "send e-mail to this person"

Please can you help with this.
Thank you

解决方案

I have searched the forum and the help and am still very confused.

I have a simple table with one of the fields e-mail.
I have a simle form for that table.

Where the contact''s e-mail comes up, (either in the form or the table) I would like Access to show me a hyperlink that when I click on it, it opens a new message to that e-mail address. Similar to when you have a hyperlinked e-mail address in MSWord and most other office programs.

In the table with the email field set the fields data type to hyperlink.

Mary


In the table with the email field set the fields data type to hyperlink.

Mary

I tried that, but that opens up the "e-mail address" in Internet explorer, thinking that is a web address!. i.e. if I type a web address it works, but it doesn''t work in the sense that an e-mail address gets forwarded to a e-mail program!


I tried that, but that opens up the "e-mail address" in Internet explorer, thinking that is a web address!. i.e. if I type a web address it works, but it doesn''t work in the sense that an e-mail address gets forwarded to a e-mail program!

Change the field back to text temporarily. Then run find and relplace and replace all http:// with mailto:

Then change back to hyperlink again.

When adding new email addresses add them with mailto: at the start of each address

Mary


这篇关于使电子邮件字段中的条目成为一个超链接,以便在Outlook中发送电子邮件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆