EmailTemplate template = [Select id, subject from EmailTemplate where name = 'My Template' limit 1];
...
Messaging.SingleEmailMessage msg = new Messaging.SingleEmailMessage();
msg.setTemplateId(template.Id);   // <<--- look
...
system.debug(Messaging.sendEmail(emails,false) );

15:34:51:342 USER_DEBUG [35]|DEBUG|Messaging.SingleEmailMessage[
getBccAddresses=null;
getCcAddresses=null;
getCharset=null;
getEntityAttachments=null;
getFileAttachments=null;
getHtmlBody=null;
getInReplyTo=null;
getOptOutPolicy=SEND;
getOrgWideEmailAddressId=0D20U0000008P2cSAE;
getPlainTextBody=null;
getReferences=null;
getTargetObjectId=0030U00000eXdLNQA0;
getTemplateId=00Xf4000000h8eaEAA;    // <<--- look
getToAddresses=null;
getWhatId=null;
isTreatBodiesAsTemplate=false;
isTreatTargetObjectAsRecipient=true;
isUserMail=false;
]

• All use the standard System Administrator profile, Salesforce license as well as the same role and permission sets 
• They're all using the same connected app client_id and client_secret.
• The passwords are always submitted as PasswordToken
• IP Relaxation is set to: Relax IP restrictions
• Permitted users is set to: All users may self-authorize
• I can login to the UI with any of the user id/password combinations 
• I have an older app still that relies on password+token to login and have verified that the tokens are all working as well.

public static void saveList(string command, list<sobject> objList, string caller){
		if ( objList == null || objList.size() == 0 ) return;
		try {
			if (command == 'insert') insert objlist;
			else if (command == 'update') update objlist;
			else if (command == 'upsert') upsert objlist;
			else if (command == 'delete') delete objlist;
		} catch (exception e){
			logError(caller, e);
		}
	}

global with sharing class update_MBI implements Database.Batchable<AggregateResult> {
	global update_MBI() { }
    global string mbiQuery = 'select account__c, sum(spend__c) spendLast12 from spend__c where age__c < 0 and age__c >= -12 group by account__c ';

	global Iterable<AggregateResult> start(Database.BatchableContext BC) {  
		return new mbiIterable(mbiQuery);
	}

   	global void execute(Database.BatchableContext BC, List<AggregateResult> scope) {
		list<account> u = new list<account>();
		for (AggregateResult ar : scope){
			id acctID = id.valueOf(string.valueOf(ar.get('account__c')));
			decimal newMBI = decimal.valueOf(string.valueOf(ar.get('spendLast12'))) / 12;
			u.add(new account(id=acctID, MBI_Monthly_Spend_Current__c = newMBI));
		}
		update u;
	} 

	global void finish(Database.BatchableContext BC) {	}
}

public with sharing class mbiIterable implements Iterable<AggregateResult> {
    private String query;

    public mbiIterable(String soql){
		query = soql;
    }

    public Iterator<AggregateResult> Iterator(){
		return new mbiIterator(query);
    }
}

public class mbiIterator implements Iterator<AggregateResult> {

  AggregateResult[] results { get;set; }
  Integer index { get;set; }

  public mbiIterator(String query) {
	  index = 0;
	  results = Database.query(query);
  }

  public Boolean hasNext(){
	  return results != null && !results.isEmpty() && index < results.size();
  }

  public AggregateResult next() {
	  return results[index++];
  }
}

global class batchClass implements Database.Batchable<sObject>, database.stateful {

	global map<id, sobject> dataStruct;
        global string q = 'select whatever from sObject';

	global Database.QueryLocator start(Database.BatchableContext BC) {
		dataStruct = map<id, sobject>();
		return Database.getQueryLocator(q);
	}

   	global void execute(Database.BatchableContext BC, list<Item__History> scope) {
		dataStruct = batchClass_tools.processScope(scope, dataStruct);
	}

	global void finish(Database.BatchableContext BC) {
        insert dataStruct.values();
	}
}

1. pick them up
2. go to the doctor
3. stop at the drug store
4. get groceries
5. return them home

1. How do I structure my trigger so it updates the changed record and related records without causing trigger recursion?
2. Is it possible to expand the scope of the before trigger to include the related records?

1. the change set received in prod only contains one item - that's not even in the original set
2. the change set in the sandbox now only contains the one unrelated item sent to prod.
3. if I clone the sent in the sandbox - all 88 items re-appear
4. If i promote the clone - the cycle starts over again.

string t = 'custom_object__c';
list<t> objs = new list<t>(); // creating a list of custom_object__c's

NO_MASS_MAIL_PERMISSION, Single email is not enabled for your organization or profile.: []

string query = 'select id, lastName, account.name, account.customField__c from contact';
list<contact> queryResults = Database.query(query);

EmailTemplate template = [Select id, subject from EmailTemplate where name = 'My Template' limit 1];
...
Messaging.SingleEmailMessage msg = new Messaging.SingleEmailMessage();
msg.setTemplateId(template.Id);   // <<--- look
...
system.debug(Messaging.sendEmail(emails,false) );

15:34:51:342 USER_DEBUG [35]|DEBUG|Messaging.SingleEmailMessage[
getBccAddresses=null;
getCcAddresses=null;
getCharset=null;
getEntityAttachments=null;
getFileAttachments=null;
getHtmlBody=null;
getInReplyTo=null;
getOptOutPolicy=SEND;
getOrgWideEmailAddressId=0D20U0000008P2cSAE;
getPlainTextBody=null;
getReferences=null;
getTargetObjectId=0030U00000eXdLNQA0;
getTemplateId=00Xf4000000h8eaEAA;    // <<--- look
getToAddresses=null;
getWhatId=null;
isTreatBodiesAsTemplate=false;
isTreatTargetObjectAsRecipient=true;
isUserMail=false;
]

• All use the standard System Administrator profile, Salesforce license as well as the same role and permission sets 
• They're all using the same connected app client_id and client_secret.
• The passwords are always submitted as PasswordToken
• IP Relaxation is set to: Relax IP restrictions
• Permitted users is set to: All users may self-authorize
• I can login to the UI with any of the user id/password combinations 
• I have an older app still that relies on password+token to login and have verified that the tokens are all working as well.

public static void saveList(string command, list<sobject> objList, string caller){
		if ( objList == null || objList.size() == 0 ) return;
		try {
			if (command == 'insert') insert objlist;
			else if (command == 'update') update objlist;
			else if (command == 'upsert') upsert objlist;
			else if (command == 'delete') delete objlist;
		} catch (exception e){
			logError(caller, e);
		}
	}

global with sharing class update_MBI implements Database.Batchable<AggregateResult> {
	global update_MBI() { }
    global string mbiQuery = 'select account__c, sum(spend__c) spendLast12 from spend__c where age__c < 0 and age__c >= -12 group by account__c ';

	global Iterable<AggregateResult> start(Database.BatchableContext BC) {  
		return new mbiIterable(mbiQuery);
	}

   	global void execute(Database.BatchableContext BC, List<AggregateResult> scope) {
		list<account> u = new list<account>();
		for (AggregateResult ar : scope){
			id acctID = id.valueOf(string.valueOf(ar.get('account__c')));
			decimal newMBI = decimal.valueOf(string.valueOf(ar.get('spendLast12'))) / 12;
			u.add(new account(id=acctID, MBI_Monthly_Spend_Current__c = newMBI));
		}
		update u;
	} 

	global void finish(Database.BatchableContext BC) {	}
}

public with sharing class mbiIterable implements Iterable<AggregateResult> {
    private String query;

    public mbiIterable(String soql){
		query = soql;
    }

    public Iterator<AggregateResult> Iterator(){
		return new mbiIterator(query);
    }
}

public class mbiIterator implements Iterator<AggregateResult> {

  AggregateResult[] results { get;set; }
  Integer index { get;set; }

  public mbiIterator(String query) {
	  index = 0;
	  results = Database.query(query);
  }

  public Boolean hasNext(){
	  return results != null && !results.isEmpty() && index < results.size();
  }

  public AggregateResult next() {
	  return results[index++];
  }
}

1. pick them up
2. go to the doctor
3. stop at the drug store
4. get groceries
5. return them home

1. How do I structure my trigger so it updates the changed record and related records without causing trigger recursion?
2. Is it possible to expand the scope of the before trigger to include the related records?

1. the change set received in prod only contains one item - that's not even in the original set
2. the change set in the sandbox now only contains the one unrelated item sent to prod.
3. if I clone the sent in the sandbox - all 88 items re-appear
4. If i promote the clone - the cycle starts over again.

NO_MASS_MAIL_PERMISSION, Single email is not enabled for your organization or profile.: []

I am following the guidelines from the Chatter guide and somehow I can't get the OAuth to work. 

It's not working from Java or curl.   Here is what I am doing:

mike$ curl --form client_id=3MVG9yZ.WNe6bxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxu5AjB4oT9kxi8SEhY --form client_secret=26542xxxxxxxxxxx78  --form grant_type=password --form username=xxxxxxxx@gmail.com --form password=xxxxxxx https://na11.salesforce.com/services/oauth2/token

What I am getting is:

{"error":"invalid_grant","error_description":"authentication failure - Invalid Password"}

I double checked and I am getting into na11 with the right password.  Is there anything else I need to do?

Here are the settings in my remote access:







No user approval required for users in this organization