Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
1

Questions
2

Replies

sending more than 10 emails

Hello All,
I 'd an issue regarding sending emails using singleemailmessage class. I am trying to send ONLY selected properties over mail.
If property is not available (Status:Sold) --> Then show error message.
Can anyone can help me!
Thank you.

public void sendRecomProp() {
 if ( !lRecomProperties.IsEmpty() ) {

newTemplate = new EmailTemplate();
newTemplate = [SELECT Id,Name,IsActive,Subject,Body,HtmlValue,Folder.Name
FROM EmailTemplate
WHERE (Name LIKE '%RecomProperties%') LIMIT 1];

if ( newTemplate!=null ) {
String urlDestino = '';

String templateSubject = 'KC Properties - Recommended properties';
String templateBody = newTemplate.HtmlValue;

templateBody = templateBody.Replace('{!Contact.Name}',( actualContact.Name!=null ) ? actualContact.Name : 'User');
templateBody = templateBody +
' ' + ' ' +
'<table style="width: 100%; border-spacing: 0px; border-color: red transparent;">';

String priceFinal = '';
for ( Property__c proppe :lPropiedades ) {

templateBody = templateBody +
'<tr>' +
'<td style="padding: 5px; width: 100px;">' +
'<img width="250" height="150" src="' + ( proppe.FirstReferenceImage__c!=null ? String.ValueOf(proppe.FirstReferenceImage__c) : Label.NoImage ) + '"/>' +
'</td>';

priceFinal = ( contactRole=='Renter' ) ?
( proppe.PriceToRentEUR__c!=null ? String.ValueOf(proppe.PriceToRentEUR__c) : 'Undefined') :
( proppe.PriceToSaleEUR__c!=null ? String.ValueOf(proppe.PriceToSaleEUR__c) : 'Undefined' );

templateBody = templateBody +
'<td style="padding: 5px;">' +
'- Property ID: ' +
'<a href="' + ( proppe.WebReference__c!=null ? String.ValueOf(proppe.WebReference__c) : 'www.kcproperties.com' ) + '">' +
proppe.Name +
'</a>' + ' ' +
'- Price: ' + priceFinal + ' ' +
'- Area: ' + ( proppe.Area__c!=null ? String.ValueOf(proppe.Area__c) : 'Undefined' ) + ' ' +
'- Address: ' + ( proppe.Address__c!=null ? String.ValueOf(proppe.Address__c) : 'Undefined' ) + ' ' +
'- Details: ' + ( proppe.Beds__c!=null ? String.ValueOf(proppe.Beds__c) : 'Undefined' ) + ' ' +
'- Baths: ' + ( proppe.Baths__c!=null ? String.ValueOf(proppe.Baths__c) : 'Undefined' ) + ' ' +
'- Build area (m2): ' + ( proppe.BuildArea__c!=null ? String.ValueOf(proppe.BuildArea__c) : 'Undefined' ) + ' ' +
'</td>' +
'</tr>';
}

templateBody = templateBody +
'</table>' + ' ' +
'You can visit any property via the link on the Property ID value.' + ' ' + ' ' +
'Best regards.' + ' ' +
'KC Properties team';

String[] addressesList = new String[]{actualContact.Email};
OrgWideEmailAddress[] lOrgAddresses = new OrgWideEmailAddress[]{};
lOrgAddresses = [SELECT Id
FROM OrgWideEmailAddress
WHERE (Address LIKE '%kcpropertiesestateagent%') LIMIT 1];

Messaging.SingleEmailMessage emailToSend = new Messaging.SingleEmailMessage();
emailToSend.SetSubject(templateSubject);
emailToSend.SetOrgWideEmailAddressId( !lOrgAddresses.IsEmpty() ? lOrgAddresses[0].Id : null );
emailToSend.SetToAddresses(addressesList);
emailToSend.SetHtmlBody(templateBody);

try {
if ( !Test.IsRunningTest() && !lOrgAddresses.IsEmpty() ) {
Messaging.SendEmailResult[] resultToSend = Messaging.SendEmail(new Messaging.SingleEmailMessage[]{emailToSend});
smsMailingResult = 'The mailing has been completed successfully. '+
'<a href="/' + actualContact.Id + '" style="color: blue; font-size: 100% !important;">'+
'Click here to return to the contact detail'+
'</a>';
ApexPages.Addmessage(new ApexPages.Message(ApexPages.severity.CONFIRM,smsMailingResult));
}
} catch (Exception error) {
smsMailingResult = 'An error has occurred, please try again later or contact your administrator. '+
'<a href="/' + actualContact.Id + '" style="color:blue;font-size:100% !important;">'+
'Click here to return to the contact detail'+
'</a>';
ApexPages.Addmessage(new ApexPages.Message(ApexPages.severity.ERROR,smsMailingResult));
smsMailingResult = '';
AUX_Methods.log(Label.ErrorSendingEmail+' - Send Email - '+error.GetMessage());
}
}
}
}

APM91
December 06, 2016
Like
0

2 replies

sending more than 10 emails

APM91
December 06, 2016
Like
0

SOLVED

3 replies

How to replace string with regex pattern, matcher and replaceFirst ? (Regex too complicated)

Hi.
I want to replace some specific words in string with anothers using pattern and matcher. Example: I want format nicely SOQL query so:
[ SELECT Id, Name FROM Account WHERE Name = 'John' ]
should be changed to:
[SELECT
   Id, Name
FROM
   Account
WHERE
   Name = 'John']

The code:

String convertInput = '[ SELECT Id, Name FROM Account WHERE Name =  \'John\' ]';
String convertOutput = '';
String regExp = '(SELECT|FROM|WHERE)';

Pattern p = Pattern.compile(regExp);      
Matcher m = p.matcher(convertInput);
    while (m.find() == true) {          
        convertOutput = m.replaceFirst('\n' + m.group(1) + '\n');

    } 
System.debug(convertOutput);

Gives error: System.LimitException: Regex too complicated

Where code:

String convertInput = '[ SELECT Id, Name FROM Account WHERE Name =  \'John\' ]';
String convertOutput = '';
String regExp = '(SELECT|FROM|WHERE)';

Pattern p = Pattern.compile(regExp);      
Matcher m = p.matcher(convertInput);
    while (m.find() == true) {          
        convertOutput = m.replaceAll('\n' + m.group(1) + '\n');
    } 
System.debug(convertOutput);

Gives output:
SELECT
Id, Name
SELECT
Account
SELECT
Name = 'John' ]

So I am confused what is so complicated in replaceFirst?
Do you have any suggestions how to solve that?

Paweł Woźniak
March 26, 2015
Like
0