Deleting Characters Left of "(" 1

[outsourceoncall]

Deleting Left of "(" +1

I have linked my Outlook Contacts and and my Outlook Sent Items in Access. I now want to associate the Contacts to the Sent Items. The only way I can see is to relate the email address. But the sent items Stores the email address in the [TO] field like this:

Elvis Presley (EPresley@aolsucks.com)

and the Contact Stores it like this email like this:

EPresley@aolsucks.com

I am no coder...what is the code to delete everything left of the first character past "(" ?

" I can do a find and replace for the last &quot".

Thanks!

 

[wemeier]

If you want to do this in a query, you could try this:

=IIF(InStr([TO],"(&quot=0,[TO],Mid(Left([TO],Len([TO])-1),InStr([TO],"(&quot+1))

This first checks for the presence of a left-parenthesis in the [TO] field. If none is found (the result is 0) then the entire [TO] field is used. Otherwise, the [TO] field is reduced by 1 byte on the right (assuming the right parenthesis is the last byte) and the characters from one byte to the right of the left parenthesis to the end of that field are extracted. This should give you just the email address.