Get outlook mail filter with variables

[KurX (Alexandre Barrère)]

Hi threre,

I’m struggling to get mails starting with a variable name.

For the variable word for example in sql it should be : like ‘word%’

I get a syntax error with the following code and I didn’t manage to fix it yet…

Here is my filter :

(not showing an error)

and after running :

Best regards,
Alexandre

[prasath17 (Guru)]

@KurX - Is this same query posted here?

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 : [image] Note that row(0).toString have the string : Assurimo in it Unfortunately i get the following error running my code : (syntax error) [image] I didn’t find how to fix that. If anyone can help, that would be cool ! Thanks, Alexandre

[KurX (Alexandre Barrère)]

Indeed, I didn’t manage to delete the first topic

[prasath17 (Guru)]

@KurX - I have added the variable as below and it worked…Please check…

“@SQL=”“http://schemas.microsoft.com/mapi/proptag/0x0037001f”" like ‘“&StrSubject &”%’ AND urn:schemas:httpmail:fromemail = ‘USPSInformeddelivery@Informeddelivery.usps.com’"

[KurX (Alexandre Barrère)]

Thanks, it worked with this :

“@SQL=”“urn:schemas:httpmail:subject”" like ‘“&row(0).ToString &”%’ AND %last7days(urn:schemas:httpmail:datereceived)%"

Didn’t know that we can use & for variables.

Have a nice day !