Hey, apologies if this is a silly question, I’m new…
I have a configuration excel file which is being looked up against to match an email subject with a company name
So EG: if the email says ‘new enquiry’ the sheet will know to put it to ‘client1’ etc.
So I have my variable of pConfig looking up to the variable of pEmailSubject: pConfig(pEmailSubject).ToString
The issue is that the email subject varies, so it will have ‘new enquiry 12345’ and ‘new enquiry 98554’ for example as the customer ID changes. How would I make it so that it essentially says if it ‘contains’ new enquiry to be looked up against?
I hope this makes sense, please ask for clarity if needed. Appreciate your help!