Replace "

[jgelpi16]

How do you go about replacing a " (double quote) in a string? I can't seem to get the replace() function to work properly. I am trying to append an HTML email that I build in VBA into a table. Only problem is I'm getting a syntax error when I try to run the append due to all the double quotes. Below is sample of code.

    strEmail = strHeader & strBody  & strFooter
    mySQL = "INSERT INTO tblEmails_Sent ([EmailType], [EmailTo], [EmailBody], [UserID]) " & _
        "VALUES ('" & strEmailType & "', '" & strEmailAddr & "', '" & strEmail & "', '" & strUserID & "');"
    CurrentDb.Execute mySQL

[jgelpi16]

Disregard...It was the ' (single quote) that was causing my problem. Replace function worked just fine.

strEmail = strHeader & Replace(strBody, "'", "''") & strFooter