Solved

access send email to a particular address

Posted on 2010-08-22
5
248 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

740 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