Send an e-mail

[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

 

[Allen Browne]

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

DoCmd.SendObject acSendNoObject,,,[MyEmailField],,,"MySubject", "My
message", True

 

[Ty]

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,,,

[MyEmailField],,,"MySubject", "My

 

[Allen Browne]

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.

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,,,

[MyEmailField],,,"MySubject", "My

message", True