Question:
How do I setup a workflow to automatically notify my sales people when a customer’s support contract is approaching expiry?
Answer:
Assuming you are using the contract entity within CRM to manage customer support contracts, you can use CRM’s built in workflow engine to automatically notify the account owner when a contract is nearing its expiry date. If you have rights within CRM to setup new workflows, navigate to Settings, Process Center, Processes within Microsoft CRM:

Click New on the toolbar to create a new workflow, and fill in the new workflow form similar to this:

Then click OK.
When the Process window appears, ensure that the scope of the workflow’s scope is set to Organization and that the ‘Start when: Record is created’ checkbox is checked.
Now we need to add the steps to the workflow; so click the Add Step button and select Wait Condition. An empty wait condition will be added, so the first thing to do is enter a description. To do this, just replace the text “Type a step description here.” with your own description.
Then click on
to edit the definition of the wait condition.
When the Specify Condition screen appears, set the condition up as follows:
In order to set the date condition (in yellow above), put your cursor into the date field and then from the right hand side select 3 in the Month dropdown, ensure Before is selected in the field below, Contract is selected in the Look for: field and then click on Contract End Date. This will then populate the date field with the dynamic value of ‘three months before the contract’s end date’.
Click Save and Close to save the changes.
The workflow’s steps should now look like this:

Now we need to add a step within the wait condition/timeout to send an email to the account manager. To do this, highlight the very bottom line in the steps by clicking on the text ‘Select this row and click Add Step’ and then click on the Add Step button and select Send E-mail.
Again, enter a description for the step by overtyping “Type a step description here.”. Then click on Set Properties to setup the email. When the Email screen opens, you can setup whatever you wish in here, but given that this is to be an internal email, the important fields to get right are the To and Subject fields.

To set the To field so that the email is sent to the owner of the customer account record, put your cursor into the To field and from the right hand side, from the Look for: field choose Customer (Account) (under Related Entities) and then choose Owner from the field below. Click Add and then OK to add the value to the To field as above.
For the Subject field, you can enter free text in here, however you can also use dynamic values to setup a context sensitive subject line. Above, I have set the line to read something like ABC Ltd Support Contract Expiry: 14 January 2012. All the dynamic fields are setup in the same way as the To field using the panel on the right hand side. You can setup something similar in the body of the email if you wish.
Once you’re happy with the contents of the email, click Save and Close to save your changes.
When you return to the Process screen, you can add more steps if you wish, for example you might want to create a new opportunity record for the account manager. Once you’re happy, click Save to save your changes, but for now don’t click Save and Close. Before the workflow becomes active, you will need to Activate it. To do this, click on Activate in the toolbar and click OK in the confirmation dialog. The Process screen will now be set to read-only because once a process is activated, you cannot change the structure of content of the workflow without deactivating it first.
Close the process screen and you’re done. For any new contracts that are setup in CRM, the owner of the customer account record will be automatically sent an email notifying them when the contract is three months from expiry, giving them plenty of time to get in touch with the customer and arrange the new contract with them.
www.consultCRM.co.uk