I am lost solving what should be a simple problem.
I have the following coding:
sbody = "Dear Customer" & vbCrLf & vbCrLf & _
"Kindly send a Purchase Order for the following"
A debug.print shows:
Dear Customer
Kindly send a Purchase Order document for the following
However when I store the text of sBody in a table, and call the value via a procedure, then a debug.print for sbody is:
"Dear Customer" & vbCrLf & vbCrLf & _
"Kindly send a Purchase Order for the following"
If I call as say, xBody and set sBody = xBody, makes no difference.
The 'string' is stored as a Memo (Long Text). I tried changing the field to Rich Text but neither solution works.
I have numerous places in the database, that when a button is clicked, a specific email message is sent to a client. Instead of storing the body and subject text in the code, want to store in a table and retrieve the appropriate one when the button is clicked.
I have wracked my brain over and over and cannot solve what appears to be a simple problem. Can anyone guide me please?
I have the following coding:
sbody = "Dear Customer" & vbCrLf & vbCrLf & _
"Kindly send a Purchase Order for the following"
A debug.print shows:
Dear Customer
Kindly send a Purchase Order document for the following
However when I store the text of sBody in a table, and call the value via a procedure, then a debug.print for sbody is:
"Dear Customer" & vbCrLf & vbCrLf & _
"Kindly send a Purchase Order for the following"
If I call as say, xBody and set sBody = xBody, makes no difference.
The 'string' is stored as a Memo (Long Text). I tried changing the field to Rich Text but neither solution works.
I have numerous places in the database, that when a button is clicked, a specific email message is sent to a client. Instead of storing the body and subject text in the code, want to store in a table and retrieve the appropriate one when the button is clicked.
I have wracked my brain over and over and cannot solve what appears to be a simple problem. Can anyone guide me please?