Email from Access

[Mikey]

I have a contacts database which contains an email field.
I want to be able to click on the content of that email
field, and have an outlook email window open, with the
recipient's address already input into the TO Field. The
recipient's address will always be different. I am
astounded that I cannot find an easy way to do this? Have
I just missed something obvious?

 

[Steve Schapel]

Mikey,

There are two relatively simple ways to do this:

1. In the table design, set the Data Type of the field to Hyperlink.
For the type of functionality you require, the data recorded in the
field will need to use the email protocol identifier, for example...
mailto:[email protected]
If you like, the addition of the "mailto:" can be automated at data
entry time, using a SetValue macro or a VBA procedure.

2. On the Click event of the textbox on your form, you could assign a
SendObject macro, leave the Object Name and Object Type arguments of the
macro blank, set the Edit Message argument to Yes, and in the To
argument, refer to the textbox using syntax such as...
=[Forms]![YourForm]!

 

[Kysteratwork]

Hi Mickey,

Would you know what code to use when applying a command button? Th
email should be empty, no subject or cc or body text.

I find a lot of links on the web, but they are all too specific. I a
using Outlook.

Thank you for any indication, since I am quite frustrated

Kysterathome

*Mikey,

There are two relatively simple ways to do this:

1. In the table design, set the Data Type of the field t
Hyperlink.
For the type of functionality you require, the data recorded in the
field will need to use the email protocol identifier, for example...
mailto:[email protected]
If you like, the addition of the "mailto:" can be automated at data
entry time, using a SetValue macro or a VBA procedure.

2. On the Click event of the textbox on your form, you could assig
a
SendObject macro, leave the Object Name and Object Type arguments o
the
macro blank, set the Edit Message argument to Yes, and in the To
argument, refer to the textbox using syntax such as...
=[Forms]![YourForm]!

--
Steve Schapel, Microsoft Access MVP
[QUOTE]
I have a contacts database which contains an email field.
I want to be able to click on the content of that email
field, and have an outlook email window open, with the
recipient's address already input into the TO Field. The
recipient's address will always be different. I am
astounded that I cannot find an easy way to do this? Have
I just missed something obvious?[/QUOTE][/QUOTE]


-
Kysteratwor

 

[Steve Schapel]

Kysteratwork,

It sounds like you are talking about a SendObject macro. Just make a
macro using the SendObject action, save and name it, and then enter the
name of this macro in the On Click event property of your command button

 

[SacCourt]

I have a contacts database which contains an email field.
I want to be able to click on the content of that email
field, and have an outlook email window open, with the
recipient's address already input into the TO Field. The
recipient's address will always be different. I am
astounded that I cannot find an easy way to do this? Have
I just missed something obvious?