Re: split the string so the email will be formatted

[alicejwz]

Re: split the string so the email will be formatted

Hi all,

I need to split the string so the email will be formatted when received.
DoCmd.SendObject acSendNoObject, , , "123xyz@companyxyz.com", , , "Add to Shipping Schedule", strg

Strg contains
123456-00 001 abc s123 06/16/2005, 654321-00 002 def r0991 06/18/2005, 987654-12 007 ghi f198 06/02/2005,

I would like the body of the email to look like this:
123456-00 001 abc s123 06/16/2005,
654321-00 002 def r0991 06/18/2005,
987654-12 007 ghi f198 06/02/2005,

Can it be done? If so where I need the code in VBA or Outlook? How would the code look like?
Thank you for your assistance

 

[Mile-O]

myString = Replace(myString, ",", "," & vbCrLf)

This replaces the comma with another comma concatenated with a line break.

 

[alicejwz]

Re: Split the string so the email will be formatted

Beautiful!!
Thanks McAbney again.