1.

Solve : vba help?

Answer»

hi all,

I have a string in outlook VBA that has many LINE BREAKS in it. I'd like to remove these line breaks so all the text is on one line.

Any IDEAS how???


When I run "msgbox strString" i get this;


Code: [Select]This is line 1


This is line 3


This is line 5

When I'd REALLY like to have;

Code: [Select]This is line 1 This is line 3 This is line 5

Any help would be fantastic!!!

Cheers guysSomething like this may help:

Code: [Select]strString = Replace(strString, vbCRLF, " ")
msgbox strString


Discussion

No Comment Found

Related InterviewSolutions