Meeting Confirmation Email

This came up on the listserv this week, so I figured I'd tell how we do meeting confirmation emails. Firstly, we require all regisrants to have an email address so we can email them confirmations.

Then weekly we run the TRS ORD660 process in ACK format for a selected meeting. This generates acknowledgement letters and (in PROD mode) stores the data in the ORD660_Processed table with the job key. The process picks up those orders that haven't had an acknowledgement letter, or have had a line item added after the acknowledgement letter date (stored on the order and populated by this process).

We then have a Crystal reoprt that pulls orders for a particular job key run of ORD660 from the ORD660_Processed table along with other pertant data (assistant email, hotel reservation dates, special needs). I'd show the query, but it's one of the longest I've written!

This data is then merged with a Word document to send out an email. One run is done for the primary email address and another is done with the same information to the person's assistant's email address (ASSISTANT is a phone location we use).

When we were on TIMSS 5 we had a similar process, but the BJS job was MTG660 in ACK mode and we used an Impromptu report to get the data from the MTG660_MASTER_TAB table based on a job key.

Applies to: TIMSS5 & TIMSS6