Email Tool-Not supporting Body and attachment at the same time

I am sending attachment by using email tool in that i need to pick the most specific file to be sent after each run but if i have setup like that only body of the email has the link of recent file .In attachment i couldn't able to sent the attachment .Meanwhile same time i am not able to send the body and attachment.

Need help on email tool .

Designer Cloud

Accepted answers

alexnajm

It looks like there’s no additional tool that’s doing my suggestion of clearing the sheet name from the full path - you can do this right before the Render tool so it doesn’t affect your Output Data stream.

All comments

alexnajm

Can you show us your configuration?

sathyaKPMG

In the email tool add section if i will give the specific file name it will pickup the file from the day it runs so if we run it for next week it is picking the same file and sending through email .But if in the body of the email i add this file name filed it is picking up the most recent run and send as a link .But i want some text in body and attachment most recent file run .

FiledName.PNG

alexnajm

If you want some text in the body, just type in whatever text you would want there - or use a Report Text tool to provide some more formatting and select that field for your email body!

sathyaKPMG

yes i have tried that but the thing with email tool is we cant use 2 strings in attachment and body , it's showing error .Only one string field we can add. Is that it works ?

alexnajm

Can you configure it that way then and show me the error? Also what version are you on?

sathyaKPMG

You can see i have added fields in both body and attachment not accepting it .

Error.docx

alexnajm

Ah, try removing the sheet name from the file name field. You may use it elsewhere in your workflow to write to multiple sheets, but I think it is erroring because it can’t separate a single sheet to send. You can use a Formula tool just before to affect the file name!

sathyaKPMG

As you said , i am using formula tool to create the File name field and using it to generate the output in the output folder and using the same filename field for calling it out in Email tool .Does it affects?

Error2.PNG

alexnajm

You are allowed to do this, but the workflow needs to run the Output Data tool BEFORE the Email tool - otherwise the file will not have been created so it can’t be attached to the email.

I would use a Block until Done to achieve this - it would have the Output Data coming out of #1 and the Email stream coming out of #2.

alexnajm

It would go right after the Formula tool creating the File Name

sathyaKPMG

Yes added block untill tool , but the same error getting again .

Capture.PNG

alexnajm

sathyaKPMG

Hi Alex , As you said i have removed the sheet name before it goes to render and email tool. Now i can be able to send the body and attachment as a field without getting sheet name not specified error.

Thanks much Appreciating your quick help on this

alexnajm

Glad it’s working!

sathyaKPMG

As you said i removed sheet name from file name it was working but today i have ran the workflow but render output not creating new file its just over writing on existing file based on what i have chosen like i have selected specific output in render tool .

So i have mapped output with output tool it is not working without sheet name mentioned.

Capture.PNG

alexnajm

It looks like you added a Table tool before your Output Data - you cannot use the Reporting tools followed by a Output Data, only followed by a Render!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703