I have a dilemma. I need to check if a text field containing an Email address, begins with a certain letter range, let's say a-m, then return the value of the email IF the first letter of the Email address falls within the range a-m or n-z or an integer. I will need to make at least 2 if not 3 calculation fields. If true it just needs to return the Email address.
WHY: I have some automated Emails being pumped out with Globiflow, HOWEVER, with Office365 can only send to 500 recipients at the same time. I am trying to break up the list and send 2-3 Emails which is within the limits of Office365. I will at least need to break this up in half, but I also have some emails beginning with numbers and need to include them as well either separately or together with one of the alphabet ranges.
Please sign in to leave a comment.