Button for Email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a possibly that I can get/create a small email button (any maybe
even with a envelope sign on it)?
On the form the user completes all details about clients including their
email address... instead of using a smart tag to link to outlook, is there a
small email button the user could press instead, so that when that is pressed
outlook would then load with the email recipient's address in the TO section?

Any info would be great. Thanks.
 
Kerry,
Check out the SendObject command in Help. It allows you to send an email
message from access. Your email field on your form can supply the address
for the TO: argument.
So place a button (ex. cmdSendEmail) on your form, and use the OnClick
event to trigger the code...
Private Sub cmdSendEMail_Click()
DoCmd.SendObject , , , Me.[YourEmailFieldName]
End Sub
Expirement with the other SendObject arguments ([Subject], [MessageText],
etc..), and set it up just the way you want.
hth
Al Camp
 
Is there a possibly that I can get/create a small email button (any maybe
even with a envelope sign on it)?
On the form the user completes all details about clients including their
email address... instead of using a smart tag to link to outlook, is there a
small email button the user could press instead, so that when that is pressed
outlook would then load with the email recipient's address in the TO section?

Any info would be great. Thanks.


Add a command button.
Code the button's Click event:
Application.FollowHyperlink "MailTo:" & ControlName

Your default email browser will open with the email already addressed.

As far as a picture on the button, click on the form's Picture
property and then on the little button with 3 dots that appears on
that line.
Select a picture from one of the available choices, or browse to any
other .bmp or .ico picture you may have stored on your computer.
 
Back
Top