Email Outbox - or query to create SENT email list

[rhaber123]

In OD, we can go to the INBOX, and download our Emails from the server, and emails are posted in the patients charts automatically when possible.

1- Is there an OUTBOX in OD ? or a way to check at the end of the day the emails that were sent by our staff?
2- or is there a query that can create an email list , with the patients names who were sent emails on a certain day or period?
(and if possible to show the text that was emailed)

[jsalmon]

Oh, I like this idea. There currently isn't a way built into Open Dental to display such information but you should definitely submit a feature request. Also, if you need it ASAP I'd recommend submitting a query request because this is information that we would be able to provide to you.

http://opendental.com/manual/featurerequests.html
http://opendentalsoft.com:1942/ODQueryR ... tForm.aspx

You can always check out our current queries to see if there is a similar one or if this has already been done (doesn't sound familiar to me though).
http://opendentalsoft.com:1942/ODQueryL ... yList.aspx

[rhaber123]

Thank you jsalmon,

In the query examples list provided in the above link, I was able to modify query number *1129, and added the period that I am interested in. The dates can be changed as needed.
After I run the query, I can expand the BodyText area to read the message, or I export the file as an excel document and expand it there where needed.

My first query, but it worked. Any Improvement is welcome.

====================================================================

/* Email Messages SENT during CURRENT MONTH*/

SELECT PatNum,ToAddress,Subject,BodyText,MsgDatetime
FROM emailmessage
WHERE MONTH(MsgDatetime)=MONTH(CURDATE())
AND YEAR(MsgDatetime)=YEAR(CURDATE())



=====================================================================
/* Email Messages SENT during a certain period of time*/
/*change the dates as needed*/

SET @FromDate='2016-09-01', @ToDate='2016-09-30';
SELECT PatNum,ToAddress,FromAddress,Subject,BodyText,MsgDatetime
FROM emailmessage
WHERE DATE(MsgDatetime) >= @FromDate
AND DATE(MsgDatetime) <= @ToDate


======================================================================

as we use a single email for outgoing messages, I removed the "FromAddress", so I can read the messages in the query result screen in OD .

/* Email Messages SENT during a certain period of time MODIFIED*/
/*change the dates as needed*/


SET @FromDate='2016-09-01', @ToDate='2016-09-30';
SELECT PatNum,ToAddress,FromAddress,Subject,BodyText,MsgDatetime
FROM emailmessage
WHERE DATE(MsgDatetime) >= @FromDate
AND DATE(MsgDatetime) <= @ToDate