Solved

How to send reminder if no account activity in last month

Posted on 2008-10-26
5
368 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

As more and more people are shifting to the latest .Net frameworks, the windows presentation framework is gaining importance by the day. Many people are now turning to WPF controls to provide a rich user experience. I have been using WPF controls fo…
What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

756 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