I have 1003 contacts in my org and I want to send them all an email. I'm limited to 250 contacts per mass email, so I would like to create lists that would split my contacts (and future contacts) to groups, lets say based on the first letter of the Last Name. So for example A-F, G-L, etc...

The problem is that the filter in the mass email contacts only supports AND and not OR. The campaign filter is the same.

Any suggestion how I can solve this and create lists that include about 200 contacts each so they'll be ready for new contacts that are added with time?

Attribution to: Dedo

Possible Suggestion/Solution #1

Try this:

Create a new Pick List custom field on the contact object, where the values of it are:

• You might want to create a workflow/after trigger - that sets the value of this field according to the name.
• The rule criteria is:

The group will be set automatically.

Attribution to: Saariko

Possible Suggestion/Solution #2

• as per Mike's comment to my first answer:

Create a Formula Custom Field

IF(
 OR( 
 BEGINS( LastName , "A"), 
 BEGINS( LastName , "B"), 
 BEGINS( LastName , "C"), 
 BEGINS( LastName , "D"), 
 BEGINS( LastName , "E"), 
 BEGINS( LastName , "F") 
 ), "A-F", 
IF(
 OR( 
 BEGINS( LastName , "G"), 
 BEGINS( LastName , "H"), 
 BEGINS( LastName , "I"), 
 BEGINS( LastName , "J"), 
 BEGINS( LastName , "K"), 
 BEGINS( LastName , "L") 
 ), "G-L", 
IF(
 OR( 
 BEGINS( LastName , "M"), 
 BEGINS( LastName , "N"), 
 BEGINS( LastName , "O"), 
 BEGINS( LastName , "P"), 
 BEGINS( LastName , "Q"), 
 BEGINS( LastName , "R"), 
 BEGINS( LastName , "S") 
 ), "M-S", 
"T-Z"
)))

You can set the mass email views according to this field.

Attribution to: Saariko
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/3369