Opening Outlook to send an e-mail from the form

[ptaylor-west]

How do you set up the property for a field that contains an e-mail address so that it will open up outlook automatically and enter the e-mail address in the send to box - I have tried hyperlink but this will only work for web sites and also by creating a hyperlink/e-mail field but this has to have a dedicated e-mail address

 

[John.Woody]

For this to work you must have outlook set as your email program in the internet properties.
Create the email field in your table as a text field and then put the field on the form.

Create an event procedure on that field on click or double click as below where Me.Cust_Email is the field name.

Dim StrInput As String

StrInput = "mailto:" & Me.Cust_Email

Application.FollowHyperlink StrInput, , True

 

[BukHix]

This thread shows an alternative method to using the hyper links. I have never used them but I hear they are a mixed bag of results.

Topic: Email a Report Using a Command Button

Post back if you do have more questions.

[This message has been edited by BukHix (edited 09-10-2001).]

 

[ptaylor-west]

Thanks John your solution was absolutely spot on.

 

[BukHix]

Ok I'll admit it, the thread I sent you to was for sending a report through email (I picked the wrong thread) but I believe the SendObject is still a better method then the HyperLink.

Anyway, gald you got it working!