attach additional files with email

Christoph Roessner

Hi,

How can I attach additional files along with, for example, sales quotation per e-mail?

These files are the picture of our product mentioned in sales quotation (therefore, the picture depends on it) and some of our catalogues.

Since I'm not too familiar with coresuite (just starting), it would be great if you could give me a step-by-step explanation.

Thanks!

Philipp Knecht

Hi Andre

Locate the DocumentRow DataBand.
Then in the GetDataScript (Not GenerateScript!) :

 LD.AddAttachement(path)

hth

Christoph Roessner

You mean DocumentRow AdvanceDataBand, I hope. On the LD.AddAttachment(path), how can I replace "path" with the path to my files (pic)?

Let's say the path to my pictures is C:mypic

and the UDF in my ITEM database referring to the picture's name is U_pic1.

I've tried the following, and both didn't work.

LD.AddAttachment("C:mypic"+DocumentRow(U_pic1)) or

LD.AddAttachment(DocumentRow("C:mypic"+U_pic1))


What is the right syntax?

Philipp Knecht

Hi Andre

LD.AddAttachment("C:mypic"+DocumentRow(U_pic1))

would be correct.

hth

Christoph Roessner

I tried that one too, but doesn't work.

Here is the error message:

Print Error in Layout: Exception of Type
PerpetuumSoft.Reporting.Rendering.ScriptException was thrown.


Any other clue?

Philipp Knecht

Hi

Is it in the GetDataScript?

hth

Christoph Roessner

Yes, the script under DocumentRow AdvancedDataband -> GetDataScript.

And the script is, just like on the other thread:

If Not Engine.IsDoublePass Then
  LD.AddAttachment("C:mypic"+DocumentRow(U_pic1)) 
End If

What is wrong, then?

Philipp Knecht

Hi Andre

DocumentRow("U_pic1"))

If you drag and drop the fields into teh script editor you won't have this errors.

hth

Christoph Roessner

I didn't know that I could drag and drop!

Now I got it. It was:

DocumentRow("RowRowItems.U_pic1")

thanks.