I figured out and had assistance with an earlier post. Now I run into another problem.
How do I export the rich text fields to Excel without the <br>,,div. etc and have it look like the formatted characters as they are in the pdf and in the database rich text fields themselves?
I am using this in VBA to export:
DoCmd.TransferSpreadsheet 1, 10, "[ReportName", "Location" & NIE & " TeportOutputName - " & Tod & ".xlsx"
I noticed the same issue with the text in the email body. I use this to add text to email body:
strMsg = strMsg & rs!Status & vbCrLf & Chr(9) & "CR " & rs!CRNumbers & " - " & rs![ChangeRequested] & vbCrLf
I need to keep the email body in plain text. Is there a way to convert back to plain text from rich text?
Do I need to yse a replace command?
Thanks