on 03-17-2014 7:09 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Sri,
you can refer the below doc to create email body
regards,
Harish
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.