[SalesForce] Sending Mass email

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?

Best 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.

Related Topic