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)
Email Outbox - or query to create SENT email list
Email Outbox - or query to create SENT email list
Last edited by rhaber123 on Wed Oct 26, 2016 7:06 pm, edited 18 times in total.
Re: Email Outbox - or query to create SENT email list
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
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
The best thing about a boolean is even if you are wrong, you are only off by a bit.
Jason Salmon
Open Dental Software
http://www.opendental.com
Jason Salmon
Open Dental Software
http://www.opendental.com
Re: Email Outbox - or query to create SENT email list
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
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