e-mail address in text field. Click on it to initiate new msg in O

[aathorpe]

In Word, if I click on an e-mail address, Outlook Express is automatically
opened and a message to that address is prepared. I would like to achieve
the same effect by clicking on an e-mail address in a standard form in Access
2000.

 

[rowiga]

You can use the Click or DblClick event to achieve this. On the email field
enter code similar to this to launch your email service with the current
email address in the To box:

DoCmd.SendObject acSendNoObject, , acFormatRTF, [YourEmailFieldName]

"acFormatRTF" is Rich Text formatting. If you want something different...say
plain text you can enter acFormatTxt or leave it blank to allow the user to
select an option at the time the email is created.

 

[Andrew Thorpe]

Fantastic. It works a treat. Many thanks
Andrew

You can use the Click or DblClick event to achieve this. On the email field
enter code similar to this to launch your email service with the current
email address in the To box:

DoCmd.SendObject acSendNoObject, , acFormatRTF, [YourEmailFieldName]

"acFormatRTF" is Rich Text formatting. If you want something different...say
plain text you can enter acFormatTxt or leave it blank to allow the user to
select an option at the time the email is created.

In Word, if I click on an e-mail address, Outlook Express is automatically
opened and a message to that address is prepared. I would like to achieve
the same effect by clicking on an e-mail address in a standard form in Access
2000.

 

[rowiga]

You're welcome

Fantastic. It works a treat. Many thanks
Andrew

You can use the Click or DblClick event to achieve this. On the email field
enter code similar to this to launch your email service with the current
email address in the To box:

DoCmd.SendObject acSendNoObject, , acFormatRTF, [YourEmailFieldName]

"acFormatRTF" is Rich Text formatting. If you want something different...say
plain text you can enter acFormatTxt or leave it blank to allow the user to
select an option at the time the email is created.

In Word, if I click on an e-mail address, Outlook Express is automatically
opened and a message to that address is prepared. I would like to achieve
the same effect by clicking on an e-mail address in a standard form in Access
2000.

 

[piggy]

OMG u rock !!!! i've been hunting for this for i dont know how many years!!!

why is this so buried and hidden..

thank you for posting

You can use the Click or DblClick event to achieve this. On the email field
enter code similar to this to launch your email service with the current
email address in the To box:

DoCmd.SendObject acSendNoObject, , acFormatRTF, [YourEmailFieldName]

"acFormatRTF" is Rich Text formatting. If you want something different...say
plain text you can enter acFormatTxt or leave it blank to allow the user to
select an option at the time the email is created.

In Word, if I click on an e-mail address, Outlook Express is automatically
opened and a message to that address is prepared. I would like to achieve
the same effect by clicking on an e-mail address in a standard form in Access
2000.