[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

access send email to a particular address

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
topUKlawyer
Asked:
topUKlawyer
  • 2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Dale FyeCommented:
Take a look at the SendObject method.  This should work perfectly for what you want to do.
0
 
topUKlawyerAuthor Commented:
`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
 
topUKlawyerAuthor Commented:
Thanks
0
 
Dale FyeCommented:
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now