Send an e-mail

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

How easy is it to have a send e-mail button?

I have a field in my database with the person's e-mail
address and I was wondering how to create a button that
would take the e-mail address field's contents and bring
it up in outlook.

Thanks.

Ty
 
Use this line in the Click event procedure of your command button:

DoCmd.SendObject acSendNoObject,,,[MyEmailField],,,"MySubject", "My
message", True
 
Allen - I don't mean to sound stupid, but I don't know
where to paste that command.

Ty
-----Original Message-----
Use this line in the Click event procedure of your command button:

DoCmd.SendObject acSendNoObject,,,
Click to expand...
[MyEmailField],,,"MySubject", "My
 
1. Open your form in design view.

2. Right-click your command button, and choose Properites.
Locate the On Click property (Event tab), and set it to:
[Event Procedure]

3. Click the Build button (...) beside this.
Access opens the code window.

4. Paste the line (it's one line!), between the "Sub..." and "End Sub"
lines.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Ty said:
Allen - I don't mean to sound stupid, but I don't know
where to paste that command.

Ty
-----Original Message-----
Use this line in the Click event procedure of your command button:

DoCmd.SendObject acSendNoObject,,,
Click to expand...
[MyEmailField],,,"MySubject", "My
message", True
Click to expand...
Click to expand...
 
Back
Top