cancel
Showing results for 
Search instead for 
Did you mean: 

Excel file(.xls) as attachment and Body(Signature) via Receiver Mail Adapter

srikanthe_sapxi
Explorer
0 Kudos

Hi PI Experts,

I have a requirement File(.txt) - PI(7.4) - mail (.xls attachment and signature in the body). Can anyone pls help me with the best approach to send excel file as mail attachment and signature in the body.

Thanks,

Sri

Accepted Solutions (0)

Answers (2)

Answers (2)

srikanthe_sapxi
Explorer
0 Kudos

Hello Experts..

Can anyone please please help me in the right direction.. File(.txt) - PI - mail (.xls attachment and signature in the body).

1. Input txt File has - MT, Header(10 fileds), Body(30 fields)

2. PI

3. Output mail should have - (excel as attachment and signature in the body like Hi Team.....XXXXX.... Thanks, Srikanth).

your help will be greatly appreciated..

Thanks,

Sri

Former Member
0 Kudos

Hi

You can try this approach

1. use mail package and java mapping to populate the mail package.

inside the java mapping do the following

a. read the text file and convert it to excel and then set it as additional attachment.

b. map the signature and body with the field 'content' of mail package.

2. on the receiver mail adapter check both mail package and keep attachment options.

Hopefully this will work.

Reference links

excel write : Excel and Java - Read and Write Excel with Java - Tutorial

set attachment:

Former Member
0 Kudos

Hi Srikanth,

Please follow below link:

Harish
Active Contributor
0 Kudos

Hi Srikant,

you you can pick the file and convert to xml using FCC in file adapter. Then you can use the xlst map to convert XML to xls, please refer the below blog

srikanthe_sapxi
Explorer
0 Kudos

Hi Harish,

Thanks for ur response

I have checked the link, with this I was only able to send the attachment and here I need to send both attachment and body in the mail(i.e., we sending mail with an attachment and some body like Hi Team.....XXXXX.... Thanks, Srikanth).

Pls help me, where I can generate both.

Thanks,

Sri

Harish
Active Contributor
0 Kudos

Hi Sri,

you can refer the below doc to create email body

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/603a7bd8-a6a0-2e10-388b-fc9cb9dae...

regards,

Harish