+ Start a Discussion

Dear All,

I need to send mails to those leads who has not opened first email which I have already sent to them...
How can I achieve it??   Through HTML status report (Unopened) filed I got those clients who didn't open an email...But how can I get those clients throgh query??

plz help  
Abhishek Tiwari 25Abhishek Tiwari 25
do you have any email communication object in your org
Pradeep SinghPradeep Singh
Hi Shital,
Try if this helps you :-
[Select Name, AccountId, (Id, TaskId, WhoId,  TimesOpened, FirstOpenDate, LastOpenDate, EmailTemplateName FROM EmailStatuses) From Contact ];
No we dont have email communication object...we directly send mails from SF