Alpha Video Training
Results 1 to 9 of 9

Thread: Automated Reports/Email

  1. #1
    Member
    Real Name
    Omar Garcia
    Join Date
    Jun 2006
    Location
    Alamo, Texas
    Posts
    582

    Default Automated Reports/Email

    Automated email...

    I'm wanting to run a script to automatically generate a report and email it to predetermined email recipients. I basically just want to run a scheduled task (runtime version) of generating a report and emailing it without human intervention.

    Has anyone attempted this before?

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Automated Reports/Email

    Take a look at script_schedule().

  3. #3
    Member
    Real Name
    Omar Garcia
    Join Date
    Jun 2006
    Location
    Alamo, Texas
    Posts
    582

    Default Re: Automated Reports/Email

    cool...thanks !

    still the email portion where no client intervention is required to send...anyone seen/done this?

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Automated Reports/Email

    Quote Originally Posted by omagarc View Post
    still the email portion where no client intervention is required to send...anyone seen/done this?
    How would an email be sent if there were client intervention?

    When you can specify that try to make it happen with code.

    Would they send a set of emails based on a date field in table? Would they send a set of emails based on a numeric field reaching a certain level?

  5. #5
    Member
    Real Name
    Omar Garcia
    Join Date
    Jun 2006
    Location
    Alamo, Texas
    Posts
    582

    Default Re: Automated Reports/Email

    I'm trying to generate reports on a scheduled bases that will email these reports "automatically" without human intervention. I guess I 'll see how to interface better with outlook client where the software is not "waiting" for someone to press "send".

    The report is based on an isblank("completed") field and will produce a result set that will tell the recipient how many studies are pending interpretation.

    I'm now thinking about "Sys_send_keys()" to simulate a human pressing "send" in the email client.

  6. #6
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,204

    Default Re: Automated Reports/Email

    You need:
    email_send()

  7. #7
    "Certified" Alphaholic
    Real Name
    Ed Barley
    Join Date
    Mar 2002
    Location
    Southern California
    Posts
    1,056

    Default Re: Automated Reports/Email

    Omar,

    Are the reports attached to the email, or are they in the body of the email?

    Regards

    Ed

  8. #8
    Member
    Real Name
    Omar Garcia
    Join Date
    Jun 2006
    Location
    Alamo, Texas
    Posts
    582

    Default Re: Automated Reports/Email

    I use alpha to generate the pdf and attach it to an email and am looking for a way to send it to predefined users.

  9. #9
    Member
    Real Name
    Sylvain Amyot
    Join Date
    Oct 2012
    Location
    Montreal, Quebec, Canada
    Posts
    66

    Default Re: Automated Reports/Email

    Hi, were you able to do it, because I am looking at doing the same thing and be curious to see how you manage to do it.

    thanks for any help you give me.

    Sylvain

Similar Threads

  1. Email pdf reports
    By kdankwah in forum Alpha Five Version 7
    Replies: 1
    Last Post: 09-23-2007, 02:19 PM
  2. Email Reports - Can You
    By johngtatp in forum Alpha Five Version 8
    Replies: 1
    Last Post: 02-18-2007, 09:21 AM
  3. Daily Automated Multiple email send
    By eldeko in forum Alpha Five Version 7
    Replies: 0
    Last Post: 10-26-2006, 02:05 AM
  4. Scheduled Email Reports
    By alanc in forum Archived Wishlist
    Replies: 2
    Last Post: 09-02-2006, 08:39 PM
  5. Email reports
    By whanigsberg in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-23-2002, 11:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •