musicloverlch laid this down on his screen :
You can use the replace command to "Double up" single quotes like this:
DoCmd.RunSQL "UPDATE tblEmailings SET tblEmailings.Body = " & Replace
(EmailText,"'","''") & ";"
It is good practice to use the replace command on any string variable
that is being used inside Append / Update query. Especially if you are
updating surnames. It defends against what I have called the Irish /
Italian problem. It only takes a single O'Malley, or D'Angelo in your
data to ruin what would have been a perfectly good day.
This email has been checked for viruses by AVG.