Question
I have a field in a database on a form that holds the email address. I want to either double click or click a command button beside it to take me to an email window in outlook, something like the mailto: command in html can you suggest any ways I can do this.
Answer
Many thanks for the question.
I have recently done this for one of my databases. I chose to add the code to the 'On Double Click' event.
To do this:
Right click on your email field, and select 'Properties' from the drop down list. In the events Window, click on the 'Event' tab, and then place your cursor next to the 'On Double Click' then click on the '...' button. Select Code Builder, this will open the coding window with two lines of code. In between these two lines of code, add the following code:
******
On Error GoTo ErrorHandler
Dim objOutlook As Object 'Outlook.Application
Dim objMailItem As Object 'Outlook.MailItem
Dim EmailAddress As String
Set objOutlook = CreateObject("Outlook.Application")
Set objMailItem = objOutlook.CreateItem(0)
DoCmd.RunCommand acCmdSaveRecord
EmailAddress = Me!Email
With objMailItem
.To = EmailAddress
.Subject = "Enter Your Subject Here"
.body = "Enter the body of your email here if you wish Otherwise delete"
.display
End With
Exit Sub
ErrorHandler:
MsgBox "Error Number: " & err.Number & " " & err.Description
*****
Hope this helps.
Note: I have used late binding, so that I do not have to reference Microsoft Outlook, otherwise you can run into strife if you try to load your database onto a computer that does not have the same version of Microsoft Outlook as the one you have referenced.
Also this code will only work if the email address is stored as text rather than the hyperlink option, as the hyperlink option adds some (invisible) text to the email address.
Do you like this tip? Subscribe to my free weekly Newsletter to receive tips weekly via email. Click Here to subscribe.