Sign in

Microsoft.com

Microsoft

Remove From My Forums

Deactivating bounced contacts in CRM from Excel spreadsheet

Question
0

Sign in to vote

Hello,

Can anyone help?

I have a list of bounced e-mail addresses from an external email marketing software in an excel spreadsheet. I want to be able to upload this spreadsheet to CRM and use it to automatically de-activate the contacts that are bounced (ie: de-activate all the contacts listed on the spreadsheet in CRM)... is this possible?

Thanks

Tuesday, December 17, 2013 11:47 AM

All replies

0

Sign in to vote
Hello,

I would suggest to use SSIS for your task.
Dynamics CRM MVP/ Technical Evangelist at SlickData LLC
My blog
- Proposed as answer by Andrii ButenkoMVP, Moderator Thursday, December 19, 2013 12:37 PM
Tuesday, December 17, 2013 1:44 PM

Moderator
0

Sign in to vote
This is really easy to do if you create a custom entity and a workflow. I described the process in detail in a blog post - Handle Bounced Emails.

The gist is create an entity that references Contact so that when you import a spreadsheet of email addresses, your workflow runs and deactivates the contact record.
- Proposed as answer by Andrii ButenkoMVP, Moderator Thursday, December 19, 2013 12:37 PM
Tuesday, December 17, 2013 2:50 PM