How to remove attachments in email without removing the record from attachements table

GANESH23
Tera Contributor

Hi Team,

I want to remove attchment from email while sending,at it is in send-ready state without removing the record from sys attachments table.

Thanks,

28 REPLIES 28

i am triggering email through scheduled reports

So you have a scheduled report....which is for sending an attachment of a report to people on a scheduled basis...and you want to remove the attachment from that email, thus sending them basically some text and that's it?


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

yes correct. i want to remove attachment from email while sending

You can clear the "report" field in the scheduled report record and then it would have no report to send, thus no attachment.

I guess you're using this as a scheduled email...instead of it's intended design, but either way, if you remove the report from the scheduled report and just have text, it'll send with no attachment.

Something like this would send with no attachment then:

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

if we clear the "report" field in the scheduled report, is attachment will insert in sys_attachment table?