Hi Edwardo
I have the same problem; perhaps Richard have a solution for us.

Chat GPT Said:

It sounds like you're encountering an issue with preserving formatting when using the API for processing text. Preserving formatting can be a bit trickier in API environments compared to interactive environments like ChatGPT. Here are a few suggestions to help address this:

Preprocess the text: Before sending the text to the API, you can preprocess it to remove any characters or formatting that might cause errors. This could involve removing carriage returns, extra spaces, or any other non-essential formatting that might interfere with the API's processing.

Use a specialized API endpoint: Some APIs offer specialized endpoints or options for handling formatted text. Check the documentation for the API you're using to see if there are any specific endpoints or parameters you can use to preserve formatting.

Encode the text: Another approach is to encode the text in a format that preserves formatting, such as HTML or Markdown. You can then send the encoded text to the API, and decode it on the other end to restore the formatting.

Handle errors gracefully: If the API returns an error due to formatting issues, you can handle it gracefully in your application by providing feedback to the user and allowing them to correct the formatting before resubmitting the text.

Provide a preview feature: If possible, consider implementing a preview feature that allows users to see how their text will look after processing before submitting it to the API. This can help catch any formatting issues before they become a problem.

By implementing one or more of these approaches, you should be able to minimize the loss of formatting when using the API for processing text.

I welcome Richards AUTOMATED solution.   If he is checking Letters to Customers, maybe he has seen this problem.

This Works:

</p> Hello</p>
</p>
</p> wht is your nam</p>
</p> Eduardo</p>

The Bot is now: Correct the following text for spelling, grammar, and punctuation ONLY. Do not reword it. It's OK to break large blocks of text up into smaller paragraphs for readability. Remove html.

Again. Need Automation. Pls

I believe I talk about this in one of the lessons you have to escape the characters in other words if you're converting to something that you're sending to the AI then you have to replace vbNewLine with \n. And then when you get a response back from the AI just reverse that process.

yes. I substituted the /n returned and it works fine. thank you.

New Suggestion:
Add a [Translate to] combo box for the script to be translated before sending it to the API.
Works like a charm.

This will translate and check your grammar as well.