 | Tracking Emails Sent |  |
 Posted: Tue Jun 23, 2015 12:45 pm |
Points: 0  |
|
| TPorter2 |
| Awesome Administrator |
|
 |
| Joined: 30 Jun 2006 |
| Posts: 334 |
| Location: Addison, TX |
|
|
|
|
|
 |
|
| Need a way to track the number of emails sent per day by a particular user. These should only be outgoing Internet emails, not Goldmine messages. Premium Edition 2014. Any thoughts? |
|
|
|
|
| Posted: Tue Jun 23, 2015 1:53 pm |
Points: 0 |
|
| DougCastell |
| GoldMine Guru |
|
|
| Joined: 15 Jun 2006 |
| Posts: 1639 |
| Location: Los Angeles, CA |
|
|
|
|
|
|
|
hmm.. the 'not goldmine messages' thing might be a little tough, but here's a start:
| Code: |
select maildate, count(*) from mailbox where userid='DOUG' and folder='SENT' and maildate between '01/01/2015' and '06/01/2015'
group by maildate |
|
|
|
|
|
| Posted: Wed Jun 24, 2015 8:08 am |
Points: 0 |
|
| TPorter2 |
| Awesome Administrator |
|
|
| Joined: 30 Jun 2006 |
| Posts: 334 |
| Location: Addison, TX |
|
|
|
|
|
|
|
| Thanks, Doug. The "no Goldmine emails" part is important, could do a filter for customer records maybe to solve that. |
|
|
|
|
| Posted: Wed Jun 24, 2015 8:36 am |
Points: 0 |
|
| DougCastell |
| GoldMine Guru |
|
|
| Joined: 15 Jun 2006 |
| Posts: 1639 |
| Location: Los Angeles, CA |
|
|
|
|
|
|
|
| well, you could also say something along the lines of rfc822 (converted into a varchar) is not like '%X-GM-USER%' |
|
|
|
|
ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin
|
