Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Other topics FAQ

Access Howto:

How to use the "SendObject" Method to send E-mail by DougP
Posted: 14 Feb 01 (Edited 8 Apr 04)

This just sends a simple text message to a anyone In or outside the building (e-mail)
We use Exchange Server and Outlook for our Mail.

So in my example "ChrisC" is in our building.
But you could send to anyone with a valid e-mail like someone@yoursite.com

DoCmd.SendObject acSendNoObject, "", acFormatTXT, "ChrisC", , , "---------HOT ORDER-------", Redinfo, False

The "False" on the end, sends it right out without user intervention.  "True" on the end, will pop up Outlook and let you send it manually or add to it, or...

This example is used to tell Chris that a Hot order has just been made and he needs to make sure it goes out UPS RED or FEDEX. So throughout the day as orders were made if they were to ship overnite then he got this e-mail.

NOTE: Outlook 2000 and newer will stop and ask if you want it to send an email that another program started. This is annoying. NO fix either. Thank all the viruses around. Microsoft had to put in something to stop them from sending emails and it thinks Access is trying to send a malicious email. So this worked great until 2001.

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close