Export Rich text to excel

[Thompyt]

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

[Micron]

I'm not sure if everyone can see the answers at this site (I can, but something tells me not everyone can). I hesitate to just plagiarize it.
https://www.experts-exchange.com/que...emo-field.html

[Thompyt]

Thanks Micron,
I used the PlainText() for the email. I am still working the excel issue now. Thanks for the link.