How to filter contacts that received email with certain subject?
In the Contacts section, I need to filter all the contacts that ever got emails Titled "Thanks" (NOT bulk emails, just simple emails). These emails are displayed here:
I tried any available lookup, yet no success. Which object should be used?
Like
Dear Yuriy,
The option proposed by Julius above should work for the described purpose.
Please use Email Participants object to get list of contacts which were in the needed bulk email's audience.
Kind regards,
Roman
Julius,
Thank you! I specified the question: NOT bulk emails, but simple emails
Dear Yuriy,
In this case you need to build filter like this:
Kind regards,
Roman
Roman Brown,
Roman, that doesn't work for me! That gives only a few contacts. For instance, Darren is not among them. I suspect the contacts don't have activities, just emails. What table stores the emails?
Yuriy Konstantinov,
Activities and emails are stored in the same object, but just in case try to remove type=email filter and check if it helps.
Best regards,
Angela