sending text via command button to email

[broadbean]

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.

 

[ByteMyzer]

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:

[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]