Ashlyn - I responded earlier and then realized I posted a bad solution.  That one is deleted.  Sorry if you got multiple notifications.

So...  You can't mix VBA into an SQL statement. You have to deal with the VBA first then use the result in the SQL.

Dim NN as String  'New Notes

    NN = MySender &  vbNewLine & "Submit this authorization upon next contact"

'You can now use the NN in your SQL

   STR = "INSERT INTO tbl_ServiceNotes (Journey_Number, Tag, Services, Notes) " & _
            "VALUES (" & JNN & ", 'ToDo','ABA', '" & NN & ")"

Unless I mistyped this should work for you.

Sorry just saw that I missed a single quote.
I believe you need   "')"   at the very end of the SQL statement

Hi Scott, for some reason don't get any notifications as to replies or updates, seems I've also checked my spam filter. Thanks so much for both being so help and thorough. Not mixing SQL & VBA, after your mention now makes total sense. Thanks again!

You are welcome.  Hope that did what you wanted.

If you're working JUST with Access (and not SQL Server) try to get in the habit of using double-double quotes instead of single quotes. Trust me. You'll get a last name like D'Angelo and it will mess up your strings.