Find e-mail messages from specific senders and recipients RRS feed

  • Question

  • I'm trying to do an advanced find of all e-mail messages sent from a sender to a few different recipients.   I can successfully find emails from the specific sender, or emails to three different recipients but the minute I try to do both activities in the one search I get no results.  I think it has something to do with the fact that it doesn't like me using participation types and activity parties related to each other more than once.

    Here is one of the examples I have tried:

    Any assistance greatly appreciated.

    Wednesday, February 12, 2014 10:30 PM

All replies

  • Hi Nicole,

    First, I think your criteria is similar to

    WHERE Participant Type = "Sender" AND (Participant Type = "To Recipient" OR Participant Type = "CC Recipient")

    That criteria is applied for every single participant party and of course there's no participant party have both "Sender" and "Recipient" Type at the same time --> No result.

    Second, because of fact above, I don't think you can archive your goals with CRM Advance Find. To do this in SQL, you usually need to write 2 SELECT query (1 for Sender and 1 for Recipient) and INTERSECT the result.

    Hope it helps.

    • Edited by Linh Giang Thursday, February 13, 2014 2:39 AM
    Thursday, February 13, 2014 2:30 AM