Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Generate email via smtp when adding a record?

Discussion in 'Information Technology' started by Mick, Jul 28, 2006.

  1. Mick

    Mick
    Expand Collapse
    Guest

    We have an access 2003 database we're using to track service requests,
    we're trying to figure out if there is a way to have an email sent when
    they add a record to the database (generally speaking when they put in
    a service request)?

    Thanks for any input.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Punjab to use vacant land to generate revenues (New Kerala) Breaking News Feb 19, 2008
    Controversial Man stands by email: "Lose the traditions, or stay in India" Hard Talk Aug 11, 2012
    Disgusting email about asthma, MS, ADD and autism Parenting Aug 10, 2011
    Man uses Facebook to hack women's email Hard Talk Jan 15, 2011
    World Racist emails: Oz 4 cops sacked, 15 face disciplinary action Breaking News Oct 10, 2010

  3. Barry Gilbert

    Barry Gilbert
    Expand Collapse
    Guest

    First, you have to have an SMTP server accessible. IIS or any other smtp
    server will work.
    To get the message to the server, I use a small freeware program called
    MailSend(http://www.muquit.com/muquit/software/mailsend/mailsend.html).
    It takes a bit of work, but you have to build a textfile and a batch file
    dynamically in your code and then execute the batch file from code.

    If you want a shortcut and are willing to spend money, look here:
    http://www.fmsinc.com/products/Emailer/index.asp

    HTH,
    Barry

    "Mick" wrote:

    > We have an access 2003 database we're using to track service requests,
    > we're trying to figure out if there is a way to have an email sent when
    > they add a record to the database (generally speaking when they put in
    > a service request)?
    >
    > Thanks for any input.
    >
    >
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Mick" <MickBurkellc@gmail.com> wrote:

    >We have an access 2003 database we're using to track service requests,
    >we're trying to figure out if there is a way to have an email sent when
    >they add a record to the database (generally speaking when they put in
    >a service request)?


    Microsoft Access Email FAQ
    http://www.granite.ab.ca/access/email.htm

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page