Can't see the attached file in the EMAIL when crate mailto in the crystal reporter

[benny_is]

Hello

I'm using the Crystal reporter and i'm using a Hyperlink Command to Send emails (mailto)

BUT! When it's Crate the Email it's not attached the File - please help

it's using the Outlook

------------------------------------------------------------------------

'mailto:'+{OCPR.E_MailL}+'?cc='+ {OCRD.E_Mail}

+'⊂ject=TEST' + '%20'+{@DocNumString}

+'&attachment=C:\1.txt'

+'&body=' +'HELLO' +'%0D%0A' + {OINV.CardName}

---------------------------------------------------------------------------

Regards

Benny Israeli

[JWiseman]

hi Benny, I have one more suggestion, but please see Ido's & Dell's suggestions first. If either of those aren't quite what you're looking for here's what we did in a recent project management application...it's a bit of work / big workaround, but it fit our needs for this project as we wanted to customize each mail that we were creating.

• We were using SAP Crystal Reports Server 4.3 & CR 2020.
• We created an 'email input' Crystal Report (set up as a form) that used both report data and had custom input controls for email creation.
• Note that passthrough HTML must be activated on the CR Server. See here for more info on adding custom input controls & activating passthrough HTML.
• We created a 'template' email in Outlook that had all of the formatting that we needed.
• This Outlook template email was exported to an .htm file and the .htm was hosted locally on Tomcat.
• When the email input report was run, the end user would select the recipients from the report data and enter in the customization that was needed for the email.
• Once satisfied with the email data the end user would update parts of the .htm via a JS function. This also created an email with the recipients & subject.
• The revised .htm was copied and pasted into the newly created email. Note that since that original html was created by an Outlook export, it could be pasted into a new email and the formatting would be OK.

If this is what you're looking for let me know if you need more info. As per above though, you need CR Server (or BOBJ Enterprise) with passthrough HTML configured for this to work.

[DellSC]

If your SAP system also has either SAP Crystal Reports Server (CRS - usually with BusinessOne) or SAP BusinessObjects (BOBJ) installed, you can put the report in either of those systems and then set up code that will schedule the report to an email destination from there. If you attach this code to a button in your ERP, then it would be a mostly automatic thing where the user wouldn't have to directly log in to CRS or BOBJ to schedule the report.

-Dell

[benny_is]

Hi

We have BusinessOne and I'm using CR Developer Version 14.2.5.2618

I put the Code But can't see attached

Any suggestion ?

Thnaks

[ido_millet]

Ken Hamady maintains a listing of 3rd-party Crystal Reports automation tools here.
Several of these tools can handle your use case.

[benny_is]

Thanks

My Basic request is to Send a Customer an Order Confirmation by Sending a Email trough the SAP

But Since we need to Add an Dynamic Word in the Body & in the Subject - SAP not gives this options

So- i Edit the std Crystal form and I add an Hyperlink which when im clicking on it

It's Crate an Email with a Dynamic word & cell that i take from the form + I need to add a PDF File (Dynamic name )

Hop it's help you

[ido_millet]

afaik, current browsers do not support the attachment argument in mailto links (security risk).

There are several other ways to automate the mailing of Crystal Reports output.

Please describe the business use case and the technical platform you are currently using.