I'm assuming the membership name is the same as the one presented in the email address. If so couldn't you use Split() to get the first entry in the email?
The email is is like belwo I think my pic is off..
I need to get to the "A27111" data.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.