Edit your two constants to:
[VBA] Const strHeader_c As String = "<html><body><font size=""3"" color=""#FF0000""><pre>" & vbNewLine
Const strFooter_c As String = vbNewLine & "</pre></font></html></body>"
[/VBA]
Edit your two constants to:
[VBA] Const strHeader_c As String = "<html><body><font size=""3"" color=""#FF0000""><pre>" & vbNewLine
Const strFooter_c As String = vbNewLine & "</pre></font></html></body>"
[/VBA]
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.