topic Re: problem sending mail in Application Development and Automation Discussions

problem sending mail

Former Member — Mon, 14 Sep 2009 13:36:12 GMT

I attach the contents of a table inside a mail as I do?

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 13:43:02 GMT

HI,

Can you explain your question properly..?

regards,

surya

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 14:06:29 GMT

i have a internal table that I attach to an email in a txt file

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 14:12:33 GMT

Hi,

yes you can attach an iternal table to a mail please use the following sample code.

*&----

*& Form F_SEND_MAIL

*&----

text

*----

<--P_I_FINAL text

*----

FORM F_SEND_MAIL CHANGING P_I_FINAL.

DATA:V_MESSAGE1(250),

V_MESSAGE2(250),

L_V_DATE TYPE CHAR10.

Begin of change UPG6_Obj1932 by MOHANTSK CTS TD6K902020
CONSTANTS TAB_MARK TYPE X VALUE '09'.

CONSTANTS TAB_MARK TYPE C VALUE '09'.

*CONSTANTS CR_MARK TYPE X VALUE '0D'.

CONSTANTS CR_MARK TYPE C VALUE '0D'.

End of change UPG6_Obj1932 by MOHANTSK CTS TD6K902020

DATA L_V_FILENAME TYPE CHAR40.

MESSAGE = TEXT-013.

APPEND MESSAGE.

MESSAGE = ''.

APPEND MESSAGE.

CONCATENATE SY-DATUM+4(2)

'/'

SY-DATUM+6(2)

'/'

SY-DATUM+0(4)

INTO L_V_DATE.

CONCATENATE TEXT-009 S_TPLNR-LOW TEXT-010 L_V_DATE INTO MESSAGE

SEPARATED BY SPACE.

APPEND MESSAGE.

MESSAGE = ''.

APPEND MESSAGE.

MESSAGE = ''.

APPEND MESSAGE.

MESSAGE = TEXT-014.

APPEND MESSAGE.

LOOP AT I_FINAL INTO WA_FINAL.

CONCATENATE CR_MARK WA_FINAL-TPLNR TAB_MARK WA_FINAL-PLTXT TAB_MARK

WA_FINAL-EQFNR TAB_MARK WA_FINAL-EQUNR TAB_MARK WA_FINAL-EQKTX

INTO OBJTXT.

APPEND OBJTXT.

CLEAR OBJTXT.

ENDLOOP.

DESCRIBE TABLE MESSAGE LINES SY-TFILL.

OBJPACK-DOC_SIZE = SY-TFILL * 255.

OBJPACK-TRANSF_BIN = 'X'.

OBJPACK-HEAD_START = 1.

OBJPACK-HEAD_NUM = 0.

OBJPACK-BODY_START = 1.

OBJPACK-BODY_NUM = SY-TFILL.

OBJPACK-DOC_TYPE = 'RAW'.

OBJPACK-OBJ_NAME = 'ATTACHMENT'.

OBJPACK-OBJ_DESCR = 'equipe'.

APPEND OBJPACK.

CONCATENATE TEXT-012 SY-DATUM '.xls' INTO L_V_FILENAME.

DESCRIBE TABLE OBJTXT LINES SY-TFILL.

OBJPACK-DOC_SIZE = SY-TFILL * 255.

OBJPACK-TRANSF_BIN = ' '.

OBJPACK-HEAD_START = 1.

OBJPACK-HEAD_NUM = 1.

OBJPACK-BODY_START = 1.

OBJPACK-BODY_NUM = SY-TFILL.

OBJPACK-DOC_TYPE = 'XLS'.

OBJPACK-OBJ_NAME = 'ATTACHMENT'.

OBJPACK-OBJ_DESCR = L_V_FILENAME.

APPEND OBJPACK.

CONCATENATE TEXT-011 S_TPLNR-LOW TEXT-010 SY-DATUM INTO V_SUBJECT

SEPARATED BY SPACE.

DOC_CHNG-OBJ_NAME = 'Mail'.

DOC_CHNG-OBJ_LANGU = 'E'.

DOC_CHNG-OBJ_DESCR = V_SUBJECT.

*Receivers

RECLIST-REC_TYPE = 'C'..

RECLIST-RECEIVER = P_DLIST.

RECLIST-EXPRESS = 'X'.

APPEND RECLIST.

CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

EXPORTING

DOCUMENT_DATA = DOC_CHNG

PUT_IN_OUTBOX = 'X'

COMMIT_WORK = 'X' "TD6K900416

TABLES

PACKING_LIST = OBJPACK

CONTENTS_BIN = MESSAGE

CONTENTS_TXT = OBJTXT

RECEIVERS = RECLIST

EXCEPTIONS
TOO_MANY_RECEIVERS = 1
DOCUMENT_NOT_SENT = 2
DOCUMENT_TYPE_NOT_EXIST = 3
OPERATION_NO_AUTHORIZATION = 4
PARAMETER_ERROR = 5
X_ERROR = 6
ENQUEUE_ERROR = 7
OTHERS = 8.

IF SY-SUBRC = 0.

WRITE :/5 'MAIL SENT SUCCESSFULLY TO THE BELOW LIST : ' COLOR 4,

/5 P_DLIST COLOR 3.

ENDIF.

ENDFORM. " F_SEND_MAIL

thanks,

Venkat

Edited by: Annamaneni Venkat on Sep 14, 2009 4:12 PM

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 14:13:32 GMT

hi,

can you show the code and tell where you have problems?

regards, Dieter

Re: problem sending mail

SuhaSaha — Mon, 14 Sep 2009 14:15:08 GMT

Hello,

Use SAP reference program BCS_EXAMPLE_2 for the basic idea.

Further details on SDN.

Suhas

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 14:16:37 GMT

Hi,

Refer to the following link to find out the required code:

Regards,

Rajesh Kumar

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 14:52:14 GMT

I can not convert the contents of internal table in the file by email attachment

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 14:58:24 GMT

Hi,

Why you need to convert the contents of internal table. that code was to convert SAP Script output into PDF and put that into an internal table. you can just refer to the code which is used to attach that internal table ti send as email.

Regards,

Rajesh kumar

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 15:08:54 GMT

????asked me to send mail to the lines drawn in the report. secodn ovoi what is the best solution

Re: problem sending mail

prince_isaac — Mon, 14 Sep 2009 15:11:40 GMT

Hie

To attach an internal table and send to mail please try using the FM

SO_NEW_DOCUMENT_ATT_SEND_API1

You will achieve your goal.

regards

Isaac Prince

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 15:16:36 GMT

have some examples of how popular the function?

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 15:18:52 GMT

Popular? Yes, it's very popular. I've used it before in many programs.

Re: problem sending mail

SuhaSaha — Mon, 14 Sep 2009 15:20:10 GMT

But the translator software the OP is using is very poor in translating )

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 15:20:48 GMT

Hi,

sorry, but do you search in SDN????

Lot of examples.

Try it and if you get problems, show these and perhaps someone can help.

Regards, Dieter

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 15:22:27 GMT

thk

Re: problem sending mail

Former Member — Mon, 14 Sep 2009 17:53:53 GMT

if you got answer please select the answered post and close the thread