Hi Guy's, hope everyone is well.
Bit of a long shot, unsure if there is an easy method or not ?
I have a text box on screen, there maybe 8 paragraphs in the text box, i may also add something from a table to either add paragraphs or change using Instr and Replace functions
There may well be around 300 paragraphs stored in a table (this is to adjust the paragraphs) according to combo selection
Regardless, if there are 4-8-24 paragraphs in the text box, i can add this to email.Body
If i am going to add to HTML.Body, it comes up with all paragraphs as 1 line, I understand I need something use replace function but rather than check all data for a character to find and replace with "<br>" to generate line feeds for HTML, is there an easy method to send an email with all paragraphs to HTML without searching and/or adding characters such as
Pipes
Hash
FullStop
Uppercase
etc...
I am trying to prevent going through a table with hundreds of paragraphs to add a Pipe/Hash or whatever to use the replace function
Hope this all make sense
There could be a website link on there so using full stops wouldn't work as it would put .com etc on a new line