E-mail file unformatted

[tjgraf]

We use SO_NEW_DOCUMENT_ATT_SEND_API1 to send mail within SAP, but are having a lot of difficult because the data comes out unformatted. The problem is that the data comes out without any carriage returns so what starts as a table with characters lined up, ends up as one LONG line of text with no hard breaks. The breaks end up in the middle of lines, while data from multiple lines will be merged together.

There must be a simple solution that we are overlooking, but can anybody point it out? I can't believe this is a problem for most people...

Thanks for your help.

 

[JoHo3009]

Hy tjgraf,

today I was facing the same problem.
I found out that you need to insert special constants before every coloumn. And there is also a special constant you have to insert before every field.

CONSTANTS: con_cret TYPE x VALUE '0D', "OK for non Unicode
con_tab TYPE x VALUE '09'. "OK for non Unicode

With this constants I fill my content table like this:

CONCATENATE s_tab-username s_tab-udate+6(2) s_tab-udate+4(2)
s_tab-udate(4) s_tab-matnr s_tab-objectid
s_tab-maktxd s_tab-maktxe s_tab-tabname s_tab-tabkey
s_tab-fname s_tab-value_old s_tab-value_new s_tab-chngind
s_tab-changenr INTO s_inhalt-line separated by con_tab .

CONCATENATE con_cret s_inhalt-line INTO s_inhalt-line. "Zeilenumbruch

APPEND s_inhalt TO t_inhalt.

Ok, I hope that you have already found the solution, but I also write this down for everybody who will have the same problem later!
Good luck and God bless you all!
Manuel

 

[JoHo3009]

Oh,
I forgot to write that this was the solution for my Excel attachment! So, I didn´t proof this with the normal text in the mails!
But maybe this can give you an idea of where to look for other solutions!

Jesus loves you!
Manuel