I'm creating an issue tracker database. The main issue for contains basic issue information (issue_id, product, issuetype, status, description, request from, assigned to).
What I am trying to do is to auto generate an email that will send the issue to the employee it was assigned to. So say I enter an issue and select "Bob Smith" as the assigned to employee, I want an email to be sent to him with information about this issue (issue type, description, request from, etc.) Is this possible in access?
Hey irw0831,
It is very possible to be able to do that, the one major problem that you're going to have is with the security "features" that surrounds MS outlook, or Outlook Express, or even sending emails in general, it does require human interaction for each email that is sent. If your job is to simply send the jobs to each person, then there is a way to do that, but if you're wanting this to run as a service in the background without any interaction from a human, Assuming you have Exchanges server with outlook clients, there is a tool that allows you to disable the email protection features that are built-in to outlook so that you can send email from that user-profile without warning you about security issues.
Look on Microsoft's Support site for that tool.
If it is on a stand-alone system with either Outlook or Outlook Express, it is going to require human interaction in order for it to be able to send email, or a use of a utility called ClickYes (you can find it a www.ClickYes.com). Since this will click Yes to every request to access the Address book and giving access to the program to send email on your behalf, this would take care of that problem. Just keep in mind that it will do it, even if it is a virus that is sending email on your behalf.
I hope that helps,
If you do need code examples, of how to send email with Outlook, then let me know.
Thanks,
Joe P.