Sending Excel sheet attachment

[Former Member]

Dear All,

I have created the workflow to send mail for GR rejection. I have used the object type BUS2045.

I need to send one excel file as an attachment with the mail. The excel file will be stored at particular location in the system. for example on c drive.

Kindly guide me how to proceed.

Thanks,

Supriya

[Former Member]

Hi,

As I said,

I have used method DISPLAYUSAGEDECISION of BUS2045 in the task. It will send the mail with attchment of the screen QA13.

Along with it i want to attach one excel file in the same document in the same mail.

So, how should I proceed?

Supriya

[Former Member]

Hi,

I tried using SOFM-Importfile. But its a dialog method. I want to attach the file in the background and send it in the attachment.

Is there any solution?

Thanks,

Supriya.

[bpawanchand]

Supriya try like this

• First create a Instance of the BO in the Workflow conatiner by declaring and passing the values of type SOFM check the structure type in SE11 there you have to pass the Folder type (EXT) Once you create the instance of the SOFm then you can use the method ATTACH of the SOFM BO and call this method in the task and atach the document that you want.

[Former Member]

Hi,

I want to send the excel file along with workitem attachment(which will open tcode QA12) and the other details such as material number,,quantity etc.

Supriya.

[Former Member]

Hi All,

How will I specify which file to be attached??

Can you please give me the complete process?

Regards,

Supriya.

[Former Member]

Can you please explain me how to use SOFM??

Supriya.

[Former Member]

Hi,

To use SOFM you have to use method attach of that Business Object.

and in activity step in business object tab use SOFM

and use method Attach.

But for you i sugest use Workflow Wizard for attachment.

It will done automatically binding for you Hope magic Works!

Regards,

Purvesh Patel.

[bpawanchand]

Purvesh Your Magic Is not Working I tried to use using workflow wizard but , the attachment will be selected dynamically during runtime not statically

[Former Member]

Hi,

But how will i use this function module in the workflow??

Supriya

[Former Member]

Hi,

Supriya for that you have to insert one activity and you have to made custom method to send that call that method with appropriate parameters and use this function module to send mail.

Hope magic works!

Regards,

Purvesh Patel.

[former_member184495]

Hi SM,

try using SOFM.Import file which allows to attach file.

Hope it helps.

Aditya

[Former Member]

Hi,

Supriya Use function SO_NEW_DOCUMENT_ATT_SEND_API1

and it will help you to send attachment.

Hope magic Works!

Regards,

Purvesh Patel.