Solved

How to send reminder if no account activity in last month

Posted on 2008-10-26
5
382 Views
Last Modified: 2013-11-27
Hi,
I'd like to set up a workflow so that if there is no email activity to or from a particular account (any of the child contacts), a reminder email is sent to the owner of that account.

Any ideas on how I could achieve this?

0
Comment
Question by:nick34567
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 15

Accepted Solution

by:
WilyGuy earned 500 total points
ID: 22812256
Not sure Workflow is the best way to go.  What would you use to call it?  Would it be manual?
The firing conditions on a workflow don't lend themselves to things "not happening"
In addition, there is no ootb way to check for something that doesn't exist.

More likely you want a custom report.  That lends itself more to a manual process, though.

I could see a SQL procedure or nightly job to run a query to check for activity related to an account.  With that information, you could update a flag in CRM (likely unsupported).

Advanced Find is another tool, but because we are looking for a "sub-entity" that is possibly NULL (if there has never been an email) that is going to be less effective.

You could create a custom field in CRM for "Last Emailed" on the Account Entity.  Then every time you create an email a workflow updates that flag.  Then you could query on that flag (you could set it initially with the account creation date, so it would never be NULL and would include accounts that had NEVER been emailed).  This should work for emails that are created in the web client and should for outlook emails, but if the client emails you and you simply track it, I am less sure.
0
 

Author Comment

by:nick34567
ID: 22817542
This has been my dilemma.  

I have already set up 'Last Contact' field on the Account entity, which is updated whenever an email is created in the database - this works with both incoming and outgoing.  I think I will set a workflow to timeout until a month after this fields value, then send notification and update last contact to the current date, and start itself again.

It's a bit messy though,and would make allot more sense if a check could be done each night.

Would the SQL procedue be hard to set up?
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22817755
Well, if you already have the flag working, you are more than half way there.

The kicker for you is how are you going to use the workflow?
0
 

Author Comment

by:nick34567
ID: 22817834
Just started doing this as I got sick of trying to think up a better way to do it.

WF1:  Update Last Contact date, fires on creation of email.
WF2:  Fires on creation of account.  I'll need to kick it off manually for existing accounts.  Times out until a month after Last contact date, sends notification, updates Last Contact date and fires itself again.  I''ve also put a 'Last Contact Name' field so I can determine whether the Last Date was set by workflow or by an actual activity - the notifications will reflect this.

Seems awfully messy though....

0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22820177
So the workflow is running against each account and IT is sending an email to the account, or the owner of the account?
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack 7.0.0.23 or Above. The following steps a…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question