How can I send an automated email notification everytime a new record is created. I have a macro set up with the send object completed, I just can't figure out how to tweak the logic so it will do it everytime a new record is created.
How can I send an automated email notification everytime a new record is created. I have a macro set up with the send object completed, I just can't figure out how to tweak the logic so it will do it everytime a new record is created.
Maybe I need to provide more detail.
I have two departments. One inputs a request and the other will work the request. The notification is for the person who will work the request as they are time sensitive and need to know a new request is out there.
The inputter will fill out the form and click submit. When clicking submit I want a macro to run that brings up an email with the form attached, but only the current record on the form. Right now my macro does everything I want only the attached report shows all records not just the current record. Does this help explain a little better than before?
It can be a form or a report, it does not matter to me as both options are available in the sendobject action. The problem I am having is the email attachment contains all records and I only want it to contain the current record I am on.
Any assistance in this regard is greatly appreciated
You can do this 2 ways, one by studying the Object Model for Outlook
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
This is probably the easiest way if your organization uses Outlook. The problem or hiccup will be that all the newest versions of Outlook will popup a dialog box asking the user to confirm the email. This is to prevent viruses from automating outlook.
This code is cleaner and will send an e-mail directly through your SMTP server, bypassing the outlook bs. I would suggest hardcoding a separate admin e-mail that everything gets sent to as well in case your departments start claiming (bs'ing) they didn't get the e-mail.
http://www.dbforums.com/microsoft-ac...t-outlook.html
You just have to play around with the layout of data you will include in the body.
What do you mean by control? Sorry I am a novice at access
Here is the query right now
SELECT *
FROM Sheet1
WHERE (((Sheet1.[ID])=[forms]![Sheet1]![ID]));
It prompts me for the Id number and it will return it for me. I would like, if possible for query to return the record Id I am currently on. Please let me know if I am missing something.
So do you enjoy not helping people solve problems and you prefer to be sarcastic? Jeez.
Updated query referencing the form control and I still have the same problem.
Would someone else be able to offer assistnace on this question?
No offense ajetrumpet but your dislike for my question is evident and your help minimal so I would prefer to work with someone else.