EMail Notification with MACRO 3

1
E-Mail Notification with MACRO 3

• frank.buschlinger_at_roche.com
• PDOD Roche Pharmaceuticals

2
Content

• Why is E-mail notification helpful?
• Instructions from Infermed
• Actual implementation
• Issues and suggested enhancements
• Summary

3
Why is E-mail notification helpful?

• Events
• Clinical
• Study Management
• Study Administration
• Action required

4
Instructions from Infermed

• Technical whitepaper available on the MACRO user
  home page
• http//www.infermed.com/macro/users/Downloads/MACR
  O30/MAIL
• Create a custom notification program
• Visual Basic program, uses MS Outlook application
  component
• Create an Arezzo Action task object and call
  the notification program in the procedure
  attribute

5
White-paper Example
6
Actual Implementation

• Custom program written in Delphi includes SMTP
  client
• No other E-mail client required
• Parameters
• Recipient's mail address(es)
• CC recipient's mail address(es)
• Subject
• Mail text

7
Actual Implemen-tation
8
Actual Implementation Process Example
Study Owner
Study Owner
Programmer
QA Tester
Release Man.
QA Request
QA Result UAT Request
UAT Result
Rel. Prod.
Change Request
9
Issues and Suggested Enhancements

• Where to get the E-mail address from ?
• Not easily derived from user full name, e.g.
• Frank Buschlinger -gt frank.buschlinger_at_roche.com
• Hans von Wedel -gt hans.vonwedel_at_roche.com
• Anna Maria von Thurn und Taxis -gt ?
• MACRO user id not available as an Arezzo function
• SMS address
• Suggestion store E-mail address in MACRO as a
  user attribute

10
Issues and Suggested Enhancements

• MACRO error when trying to remove/paste a task in
  the Arezzo composer (RTE 91, Object variable or
  With block variable not set)
• Integrate E-mail / SMS notification as a MACRO
  feature

11
Summary

• Useful and working feature
• Roche Diagnostics plans to implement E-mail
  notification for administrative study definitions
  (Change Request, User Access Request)