How to attach Excel file in Mail Receiver Adapter?

Advertisement

Hello Experts,
In R/3 coding I have Internal Table data available for which i have to generate an Alert mail with Excel file attachment.
This is the scenario of Proxy sender to Mail Receiver. but I don't know how to convert the Internal Table data into Alert mail excel File attachment.
Please suggest me.
Regards,
Jagesh

Advertisement

Hi Santhosh,
Thanks for your suggestion.
But without using XSLT mapping also, I have generated the Excel File attachment.
Throgh R/3 coding I am passing following.
G_ALERT_INPUT-MT_R3REQUEST_MAIL_SEND-MAIL-FROM = From Mail Address.
      G_ALERT_INPUT-MT_R3REQUEST_MAIL_SEND-MAIL-TO = TO Mail Address.
      G_ALERT_INPUT-MT_R3REQUEST_MAIL_SEND-MAIL-SUBJECT = 'Test Alert mail'.
      G_ALERT_INPUT-MT_R3REQUEST_MAIL_SEND-MAIL-DATE = SY-DATUM.
      G_ALERT_INPUT-MT_R3REQUEST_MAIL_SEND-MAIL-CONTENT_TYPE =   'text/plain;name="CSV_data.csv"'.
      G_ALERT_INPUT-MT_R3REQUEST_MAIL_SEND-MAIL-CONTENT = 'Testing1,Testing2,Testing3'.
      G_ALERT_INPUT-MT_R3REQUEST_MAIL_SEND-MAIL-CONTENT_DISPOSITION = 'attachment'.
And in the Mail Receiver Adapter i have configured as following.
Use Mail package and Keep Attachment both options are selectd.
So I am getting the data in different columns in the excel file But How to set the Next ROW in Excel file?
I thnk i am missing something in CONTENT value.
Regards
Jagesh

October 11, 2015

How to attach Excel file in Mail Receiver Adapter?

Hello Experts, In R/3 coding I have Internal Table data available for which i have to generate an Alert mail with Excel file attachment. This is the scenario of Proxy sender to Mail Receiver. but I don't know how to convert the Internal Table data in

How to get zip file in SFTP receiver adapter

Hi Experts, we got one scenario, which the PI need to pick the .zip file from file path using  file adapter and process to SFTP server with same name and extension .zip. we tried using ASMA setting and when ever we are placing the '*' in receiver cha

Mail Receiver Adapter - Flat File as Attachment

Hello, I would like to send a flat file as attachment using an E-Mail receiver communication channel. The flatfile is picked up beforehand using a file sender channel, so there is only routing necessary in PI. Is it possible to send the flatfile as a

How to attach multiple file in one mail

Hi, I've problems with sending multiple files via Gmail account (Ipad version)  When sending the photo or video, I've to just click the photo and choose send to mail one by one. Any simpler way?  Sometimes i did sent both mpg and jpg but the reciepie

How big of a file can I receive?

Not sure if there is an error or if the file is too big.  My other email provider will allow an email with several pictures attached to be received.  When I forwarded it - it failed.  Then when the sender sent it to my verizon account it failed as we

Hi, I am user iPad and I do not know how can attach a file into email e.g. CV.  Thanks

Hi, I am user iPad and I do not know how can attach a file into email e.g. CV.  ThanksYou attach files within the app that creates the file or within the app that the file is saved. For example you email photos from within  the Photos App itself. Typ

Date formatting issue when sending excel file via mail

hello People , I am facing date issue . I have inetrnal format of date as yyyymmdd. I am converting it into  YYYY-MM-DD. CONCATENATE gs_output-end_date(4)                     gs_output-end_date+4(2)                     gs_output-end_date+6(2)        

HT6154 how to download the files from mail like gmail or yahoo or hotmail to my iphone 5s.I have not seen the option in my iphone 5s

how to download the files from mail like gmail or yahoo or hotmail to my iphone 5s.I have not seen the option in my iphone 5sDownload what files? What is the actual problem that is occurring?Read other 2 answers

How to Zip Excel files using File Adapter?

Hi, We have tried to ZIP the Excel file with  PayloadZipBean in File adapter. But we faced some issue while zipping. We have seen some zunk data in excel file after zipping with PayloadZipBean. Someone please help how to zip Excel files in PI with Fi

Error in Mail Receiver Adapter

Hi Everyone,     I have been doing Mail Receiver Adapter Scenario.I am getting this error in Adapter Monitoring in Runtime Workbench. <b>not initialized: failed to initialize the channel: com.sap.aii.messaging.util.URI$MalformedURIException: no sche

How to attach a file (PDF etc.) to an email?

Hi I need to attached a file to an email, how do I do this does anyone know? Files such as pictures, pdf etc.Until a week ago I was using an 18 mth old HTC3600 with Windows Mobile. I had a bunch of files stored on the 2Gb SD card that I'd send client

Problem in attach a file during mail

I am facing problem while attaching a file during mailingWhat file ? If its some Office document (word / excel) .. first open the document and then (...)-->share and select your mail client ..Read other 2 answers

How to attach a file in the utl_mail utility in oracle 10.2.0

hi, where is the default file destination to attach a file in the utl_mail utility in oracle 10g. i have to send an attachment.. regards, Deepak Edited by: Deepak_DBA on Nov 4, 2009 3:10 PMHI, I have succesfully created utl_mail and send mail.. but c

How to generate Excel files in Oracle Reports

Hi, I've already built a JSP using oracle reports and Deploy on the report service. I also add a button to the left of the JSP.The next thing I want to do is:when user click on the button, the system will prompt a excel file contains the same content

How to read excel file in document library and store excel content in sql table

Hello, Can anyone help me how to read the excel file present in document library and store the content inside excel into sql table? Please let me know the ways to acheive this. Feel free to give your suggestions. Thanks, Cool DeveloperHi! this code i

How to attach a file to an email in EMOD

People I can place an hiperlink to a file emails from email marketing on demand. What my people wants is to attach a file. Is this possible??? Thanks in advance for your help Ruben AbuinWell you have to put this file in your hosting library and then

How to upload excel file in application server??

Hi, How to upload an excel file into internal table in background mode from application server? ThanksHi vipin, check this it may help you... hope below links helps you Export the report list to Excel Sheet http://www.sapdevelopment.co.uk/file/file_u

How to convert excel file into xml file

Friends Will you please help me out becz i am daily getting excel file from SAP which i have to translate into the xml file. Waiting for ur reply. HiteshDepends on how your excel document looks like and what you wish to accomplish. First, save the ex

How to open rar files from mail on iPad2

Is there any way to open archived rar files from mail ?Try downloading an App which handles RAR files like iUnarchive. See http://itunes.apple.com/us/app/iunarchive/id368411864?mt=8 If you have this App Mail will offer you an option to Open in... thi

How do repair Excel file?

Microsoft autorepair function didn't rescue my Excel file. What other xls repair tool exists for a recovering lost worksheets?When a Microsoft Excel file is corrupt or damaged, then you can try several methods to repair and recover data from it: 1. F