Solved

access send email to a particular address

Posted on 2010-08-22
5
245 Views
Last Modified: 2013-11-28
Wonder if there is a flat pack solution to this?

I should like a command button that when pressed sends a message like

subject: new entry has been made in accounts database

to a defined email address. ie to notify a specific accounts person (say accounts@acme.com) that a new entry has been made.

anyone assist please. many thanks
0
Comment
Question by:topUKlawyer
  • 2
  • 2
5 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 33495007
Access includes the SendObject method. You can use it to send email:

DoCmd.SendObject acSendNoObject, , , "someone@somewhere.com", , , "MySubject", "MyBody", False

This uses the default email client. In some casese, this can trigger security warnings, specifically on Outlook platforms. If you need more robust capabilities, I'd suggest something like vbMAPI from www.everythingaccess.com.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 33495012
Take a look at the SendObject method.  This should work perfectly for what you want to do.
0
 

Author Comment

by:topUKlawyer
ID: 33495232
`thanks guys

am awarding full points to LSM because I have got full instructions which I have put into place and works well

I couldnt put fyed's helpful hint without more.

hope thats ok guys
0
 

Author Closing Comment

by:topUKlawyer
ID: 33495236
Thanks
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 33496566
LSM was quicker to the draw than I was.

For a "topUKlawyer", I would think research and reading would be right up your alley.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now