Outlook Restrict Method From Access

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

Outlook Restrict Method From Access