Problem filtering emails (SQL) with variables

Help
, ,
1

Hi there,

I’m currently working with outlook and I’m encountering a problem filtering mails.

I need to use variable and i have the following filter :

image
image1469×44 16.7 KB

Note that row(0).toString have the string : Assurimo in it

Unfortunately i get the following error running my code : (syntax error)

image
image706×30 2.09 KB

I didn’t find how to fix that.

If anyone can help, that would be cool !

Thanks,
Alexandre

2

Hi @KurX … Below is my hardcoded values for Subject …

image
image793×62 3.33 KB

In your, seems like you are missing the % and quotes should be single …

3

Hi thanks for the response,

I have not the first % because I just need to get mails with Assurimo + anything.

I tried with single quote but still not working