Outlook Restrict Method From Access

[johnnyc]

Hey Guys,

There are different reasons why I am looking for this to happen but basically i have the below script:

For Each Item In offexchfldr.Items.Restrict("[SenderName] = '" & frmfm & "'") ' Select Items that match Sender Name on form
If Item.TaskSubject = subid Then
Item.Categories = frmcat ' Update category from form to outlook
Item.Save
End If
Next

This script checks every item in the outlook inbox where the item.SenderName = my database sendername

This works every time except for when the sendername has quotes or single quotes in their name. So i am trying to utlize the replace method on the item sendername before trying to find the items in the inbox but its not working. Below is my attempt that does not work.

Thanks for your help guys!!

For Each Item In offexchfldr.Items.Restrict("Replace([SenderName],',"") = '" & frmfm & "'") ' Select Items that match Sender Name on form

 

[pbaldy]

The a Replace would look like:

Replace([SenderName], "'", "")

 

[johnnyc]

Hey Paul,

that is true but because its in the restrict string, that also errors.