Hi,
I am trying to create a .findfirst in my recordset based on the subject title of an email.
My problem starts when my subject has special character such as ', '', ", "" and MS access gives a "missing operator" error. Has anyone had this problem before and how did you work around it?
My code is :
.FindFirst ("EmailSubject = '" & oMailItem(EmailCounter).Subject & "'")
I am trying to create a .findfirst in my recordset based on the subject title of an email.
My problem starts when my subject has special character such as ', '', ", "" and MS access gives a "missing operator" error. Has anyone had this problem before and how did you work around it?
My code is :
.FindFirst ("EmailSubject = '" & oMailItem(EmailCounter).Subject & "'")