Set a Field as an email field with hyperlink to Outlook

T

Trial & Error

I have a form that accepts staff info.
One piece of that info is their email address.

Is it possible to have access recognize email addresses for what they are
and allow a hyperlink to be created so that when clicked, Outlook will
automatically launch???

Better yet... once that problem is solved, can an automatic message be
generated and entered as the text body for the message?

Ideally I would like to be able to click on the staff members email address
when viewing it in a form, and have outlook launch, and a message body be
automatically entered.
I would prefer to be able to send the message myself and not have it send
automatically.... possibly allowing for changes or additions to the message
to be made.
 
D

David Lloyd

Regarding the clicking on a hyperlink to allow an Outlook mail to be
generated, you can prefix a "mailto:" to the beginning of the email address
to make it generate an email.

If you are interested in setting the body of the email, one alternative is
to append additional information onto the hyperlink constructed as described
above. For example:


Mailto:[email protected]?Subject=Gettysburg Address&Body=Four score and seven years
ago...

A second alternative is to use the SendObject method to specify the subject
and body of the email message, and then show the email for further editing
and/or adding of attachments. Access help has more information on all the
parameters for this method.

A third alternative is to use Outlook Automation. Please see the following
KB article for more information.

http://support.microsoft.com/default.aspx?scid=kb;en-us;209948



--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a form that accepts staff info.
One piece of that info is their email address.

Is it possible to have access recognize email addresses for what they are
and allow a hyperlink to be created so that when clicked, Outlook will
automatically launch???

Better yet... once that problem is solved, can an automatic message be
generated and entered as the text body for the message?

Ideally I would like to be able to click on the staff members email address
when viewing it in a form, and have outlook launch, and a message body be
automatically entered.
I would prefer to be able to send the message myself and not have it send
automatically.... possibly allowing for changes or additions to the message
to be made.
 
Top