Problem filtering emails (SQL) with variables

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 :

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

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

I didn’t find how to fix that.

If anyone can help, that would be cool !


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

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

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