Form field formatted for Outlook mail

  • Thread starter Thread starter BobV
  • Start date Start date
B

BobV

I have a form on which I have a field for a contact email address. How
would I designate this field so that, when you click on it, it will open up
Outlook to send an email to the individual.
 
Hopefully you have done a bit of code so will understand
when I say you have to start a code module in the OnClick
event of the text box In this module fire the SendObject
function and it will Open your default email application
and put in values you specify such as To: Subject:
Message:... Here is a snipet of the help file for
SendObject.
-Cameron Sutherland

Example
The following example includes the Employees table in a
mail message in Microsoft Excel format and specifies To,
Cc, and Subject lines in the mail message. The mail
message is sent immediately, without editing.

DoCmd.SendObject acSendTable, "Employees", acFormatXLS, _
"Nancy Davolio; Andrew Fuller", "Joan Weber", , _
"Current Spreadsheet of Employees", , False
 
Actually, I didn't want to send anything.....all I want is when I click on
the email address in the field, it opens up Outlook and the email address
that I have in that particular record is inserted into the To: block of a
new mail message.
 
Back
Top