Email issues using VBA

[fgssr]

I send a message and it comes looking like:

Hello FrankS, SO, Delivery or Shipment#: 137252196 Error Reason #: Confirmation does not match customer PO Date A1: 07/17/2023 Issue: Confirmation does not match customer PO Please respond to this email confirming review and closure. No further action needed.


If there is anything else I can assist you with, please, do not hesitate to ask.

Have a blessed day!

Thanks,

Frank Sperry

CUSTOMER SERVICE ANALYST

Dorman Products 25 Dorman Dr. Warsaw, Ky 41095 p: 800.523.2492 | f: 859.567.7010

How do I get the line in red text to separate like a normal email?

Thank yu and have a super day!

 

[Micron]

Try inserting either vbCrLf (carriage return/line feed) where you need it. Or insert Chr(13) and Chr(10) where needed. Or if the email body is html or rtf you can use html codes like <BR> for line break or <P> for new paragraphs. You will have to concatenate regardless, as in
.Body = "Hello FrankS," & vbcrlf & "SO, Delivery or Shipment#: 137252196" & vbcrlf & "Error Reason #: Confirmation does not match customer PO Date A1"
and so on
Seeing your code (within code tags - vba button on posting toolbar) would eliminate some guessing.

 

[fgssr]

Thank you very much Micron,

Have a super week!

 

[Micron]

Glad I could help & thanks for the recognition.