Results 1 to 6 of 6
  1. #1
    sai_rlaf is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    44

    Automated Email Notification

    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.

  2. #2
    sai_rlaf is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    44
    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?

  3. #3
    sai_rlaf is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    44
    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

  4. #4
    WAstarita is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2011
    Location
    consult-wa.com
    Posts
    5
    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.

  5. #5
    sai_rlaf is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    44
    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.

  6. #6
    sai_rlaf is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    44
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. disable email notification by Outolook Express
    By maxbre in forum Programming
    Replies: 0
    Last Post: 12-02-2011, 05:19 AM
  2. automated email sent from records in form
    By hmcquade in forum Forms
    Replies: 2
    Last Post: 05-23-2011, 08:45 AM
  3. Automated email from access
    By jfuller in forum Access
    Replies: 3
    Last Post: 04-11-2011, 02:56 PM
  4. Automated Email Reports - monthly no clicks
    By Bamber in forum Reports
    Replies: 1
    Last Post: 05-12-2010, 12:34 PM
  5. Replies: 1
    Last Post: 03-02-2010, 10:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums