email link

[mikeinohio]

i have a field (textbox) on a form called emailaddress, is there a way to be
able to enter the email address in that text box and then have it open up
the defualt email editor and send a email if it is clicked

 

[Arvin Meyer [MVP]]

Lookup SendObject in the help files. An example is shown at:

http://www.datastrat.com/Download/EmailSenate2K.zip

If using Outlook, have a look at the code at:

http://www.datastrat.com/Code/OutlookEmail.txt

 

[mikeinohio]

Thanks Arvin, another question i see it talkin abut attachments in the code i
just wantitto open outlook with theemail address in the to sender space.

thanks again mike

 

[Arvin Meyer [MVP]]

You can use something like this on a textbox which contains the email
address in a text field:

Private Sub txtEMail_DblClick(Cancel As Integer)
Dim strMail As String
strMail = "#MailTo:" & Me.txtEMail & "#"
Application.FollowHyperlink HyperlinkPart(strMail, acAddress)
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com