You need to sign in to do that
Don't have an account?
aparna d 1
Email notification using triggers
Hi Everyone,
I am struck to display opportunity owner in email notification using triggers. Below is my code, I am getting error ple any one give me solution
I am struck to display opportunity owner in email notification using triggers. Below is my code, I am getting error ple any one give me solution
for(sObject m : trigger.new) { Miles__c mile = (Miles__c)m; mileCaseid.add(mile.Case__c); mileOppid.add(mile.Opportunity__c); // Miles__c oldmile = (Miles__c ) trigger.oldMap.get(mile.id); //} map<id,Case> casemap =new map<id,Case>(); list<case> lstcase = [select id,CaseNumber,Revision__c,Priority from case where id in : mileCaseid AND RecordTypeId = :Caserectypid ]; System.debug('lstcase'+lstcase); map<id,opportunity> oppmap = new map<id,opportunity>(); list<opportunity> lstopp = [select id, name,Owner.Name,Region__c from opportunity where id in : mileOppid]; System.debug('lstopp '+lstopp ); if(!lstcase.isempty()) { for(case cse:lstcase ){ casemap.put(cse.id,cse); } // if(!lstopp.isempty()) // { for(opportunity opp:lstopp){ oppmap.put(opp.id,opp); } for(Miles__c mm : [select id,name,Status__c from Miles__c] ){ // Miles__c mile = (Miles__c)m; string oldmile = mm.Status__c ; // Miles__c oldmile = (Miles__c ) trigger.oldMap.get(mile.id); if(mile.Status__c == 'Completed' && mile.Status__c != oldmile && mile.Case__c!= null && mile.RecordTypeid == Milerectypid ) { //system.debug('milestattusold'+oldmile.Status__c); milemap.put(mile.id,mile); string sub = casemap.get(mile.Case__c).CaseNumber + mile.Opp_Inquiry__c+'Notification of Milestone Completion'; mail.setSubject(sub); mail.setHtmlBody( '<html lang="en">'+ ' <head>' + ' <meta charset="utf-8"/>' + ' <meta name="viewport" content="width=device-width" />' + ' <br/>' + ' <br/>' + ' </head>' + ' <br/>' + ' <b>Inquiry Number: </b>' + (String.isBlank(mile.Opp_Inquiry__c) ? '' : mile.Opp_Inquiry__c) + ' <br/>' + ' <b> Case : </b> ' + (String.isBlank(casemap.get(mile.Case__c).CaseNumber) ? '' : casemap.get(mile.Case__c).CaseNumber ) + ' <br/>' + ' <b> Case Revision : </b>' + (String.isBlank(casemap.get(mile.Case__c).Revision__c) ? '' : casemap.get(mile.Case__c).Revision__c) + ' <br/>' + ' <b>Opportunity Owner: </b>' + (String.isBlank(oppmap.get(mile.Opportunity__c).Owner.Name) ? '' : oppmap.get(mile.Opportunity__c).Owner.Name) + ' <br/>' + ' </html>' ) ; } }