sending text via command button to email

broadbean

Registered User.
Local time
Today, 19:24
Joined
Oct 24, 2007
Messages
15
After inputting data into a text box on a form i want to click on a command button which will open an email program and then put the text there so i can send it.
 
You might try something like the following. Let's say you have a command button on your form named cmdSend. Set the button's On Click property to [Event Procedure]. Then, in the form's code module, paste the following code:
Code:
[COLOR="Navy"]Private Sub[/COLOR] cmdSend_Click()
[COLOR="DarkGreen"]' NOTE: modify the recipient, subject and message text as appropriate[/COLOR]
    DoCmd.SendObject acSendNoObject, , , _
        "recipient@email.com", , , _
        "Subject", _
        "Message Text", _
        [COLOR="navy"]True
End Sub[/COLOR]
 

Users who are viewing this thread

Back
Top Bottom