none
E-mailer Advice needed RRS feed

  • Question

  • Many years ago, I developed an application for a client, that sent out e-mails to employees based on data in the application.  I used FMS's Total Access E-mailer to do it and it has been working fine ever since.  Didn't need any support and as a result, I have forgotten how to use it!  Now all the sudden, it stopped working at the client site and my site as well.  I cannot get it figured out yet, but am still working on it.

    I am contemplating replacing the Total Access Emailer with my own VB code, using the docmd.sendobject method to send reports containing the e-mail.  What do you all think of that methodology?  Is it a good or bad idea?  Is there better methodology?

    Any/all advice/suggestions are welcome.

    Tuesday, November 5, 2019 5:30 PM

All replies

  • Nothing wrong with SendObject, but my question would be why did you use the Total Access Emailer?  There must have been a reason as SendObject has been around a long time.

    Do you get any errors?
    Have you contacted FMS for support?
    What has recently changed (software, email, ...)

    Here's an article on e-mailing from Access http://www.devhut.net/2018/02/16/ms-access-how-to-send-an-email/


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Tuesday, November 5, 2019 5:44 PM
  • Daniel,

    Thanks for your quick response.  I cannot remember why total access e-mailer was used, that many years ago, I didn't know much about VBA and I think that was the simplest out of the box solution.  I have since rewritten it for another company that wanted to use a application called Febooti to send their e-mails.  Their IT manager didn't like total access emailer, so I wrote VB code that created text files in a location where Febooti sent them as e-mails.  The IT manager didn't want to have an e-mail client installed on the machines that ran it.

    Now, this customer doesn't care how I send them, and has an e-mail client installed on all machines that need to send.  I already have code/infrastructure in place that could easily be modified to accommodate the SendObject function.

    I was looking to see if there is a reason I should stay away from SendObject.

    I am trying (Without much luck)  to contact FMS for some support, we will see what happens.  I cannot think of any thing specifically that has changed.

    Tuesday, November 5, 2019 6:20 PM