Simple Sintax in VB Script inside Outlook Form

[Grippen]

Hi,

I'm having problems with VB SCript Sintax with using "Restrict" function.

I get the following script working fine....


Set myItems = oCurrentFolder.Items
Set myRestrictItems = myItems.Restrict ("[Op Title] = 'Fred'&quot
For Each myItem In myRestrictItems
myItem.Display
Next

But I want to replace 'Fred' with the value of a user defined field called "Customer".

I've tried all sorts of variations around...

Set oTitle = item.userproperties.find("Customer&quot
Set myRestrictItems = myItems.Restrict ("[Op Title] = oTitle&quot

What am I missing???

Thanks

 

[ETID]

if not already dimensioned, then dimension customer as a string

and lose the quotes, also you may have to use the trim function to get rid of any leading or trailing spaces in the variable