Please find the step by step procedure for sending a mail in a report Let us see how XSLT mapping and mail package helps in sending a formatted |
|
h4. Source structure |
|
h4. Import mail package as External Definition |
|
h4. Create Outbound Message Interface of type MT_Source |
|
h4. Create Inbound Message Interface using the imported mail package |
|
h4. Interface Mapping: Select the mapping type as ‘XSL’ and |
|
Now we are done with the design. Activate all the relevant objects. |
|
Do the normal configuration like any other scenario. In the receiver communication channel make sure that you are selecting the Use Mail Package . |
|
h4. Receiver Communication channel |
|
Since we are using HTML tables for formatting, we can even copy the mail |
|
h4. Copy the mail |
|
h4. This is how it looks when you paste in Excel |
|
h4. Pasting in Word looks like this in a tabular format |
|
The same can be done using any type of mapping, XSLT is not the only solution But XSLT makes life simpler in this kind of scenarios. |
Also see eMail Report as Attachment (Excel/Word).
very informative one..good work
Rgds
Kishore
You can also refer the blog by Michal The specified item was not found. regarding the mail pacakge.
Thanks,
Prakash
Excellent Blog. Keep up date
Thank you
sati
Thx
Matt
Thanks..
There is no XSD posted in this Blog. Are u talking about the mail package XSD? You can download it from this link
https://websmp205.sap-ag.de/~sapidb/012006153200000361852004E/ximail30_xsd.txt
Thanks,
Prakash
But I also not get any headings in my email just the standard body values like:
Delivery Number, Order Number, etc.
Did you resolve this problem Matt?
Hi Roy,
Delivery Number OrderNumber (this line is available)
0080674770 000326 (this line is emtpy)
Hi Roy,<br/><br/>Are you sure you added this line<br/><xsl:text xsl:space=”preserve”>These deliveries has been completed:</xsl:text> <br/>in your XSLT as shown in the blog.<br/><br/>0080674770 000326 (this line is emtpy)<br/><br/>If the above line is not appearing check if you have given correct XPATH (including the namespaces if any)<br/><br/>Regards,<br/>Prakash
Yes I have, I have build your scenario, so all the lines are identical like in your Blog.
Only when I add the xsd as External Definition I see thow Messages in the Messages tab.
MailReceipt and Mail.
Where can I check if I use the correct XPATH?
At Imported Archives, where I open the zipped xsl mail, there is my Path empty, is that correct? and how can I add there a path name?
In the XSLT program just try changing the line “MT_Source/row” to “//row”. This is another way to represent the XPATH
If you still face the problem do let me know and post your source XML.
Regards,
Prakash
Gr. Roy
Very nice Blog . I am getting only Headers Like DeliveryNumber OrderNumber Ship_To Name like that no data .<br/><br/> My Source Message Type is having structure like MT_FILEINPUT/Record/Row with in that Row whole structure whole data is there . Target i am setting as Mail package .<br/><br/> <xsl:for-each select=”ns0:MT_FILEINPUT/Record/Row”><br/><br/> I have added all things what you have specified like.,<br/><br/> <xsl:text xsl:space =”preserve”>These Deliveries has been Completed</xsl:text?<br/><br/><br/> May I Know what mistake i have done ? Is there any mistake in XPATH function.<br/><br/><br/> it is Really Excellent Blog please Keep Blogging<br/><br/>Best Regards.,<br/>V.Rangarajan<br/><br/>
please suggest ASAP. I am facing this problem.
you can mail me-rhushikesh7584@gmail.com
very informative & useful blog…
Kishore
Can any one tel me where to download the referede mail package.
best regrads
Hi,
Can u please post the xslt code here?
u have imported the mail.xsl but didn’t posted the code.
thanks in advance.
Hi Experts,
I need to create the exact scenario and I found this blog very helpful.
I haven’t found the XSLT code in the blog. Please email me the code if possible.
My email address : praveenkv.xi@gmail.com
Thanks and Regards,
Praveen