AnsweredAssumed Answered

Automated "send mail" with individual PDF's (scripting problem)

Question asked by FemkeMaes on Jun 11, 2014
Latest reply on Jun 11, 2014 by philmodjunk


Automated "send mail" with individual PDF's (scripting problem)


     Hello all, I have a database in which I created invoices ( layout). I need to e-mail all the individual invoicees their own invoice as a PDF. I have all the e-mailadresses.

     With 'send mail' this works, but I have to send out more than 1.000 invoices so I was hoping this could be automated. I am unsure on how to create the PDF's. This thread was usefull, but somehow does not attach the PDF's...Also, I assume that it works for one record only and I need to loop through a lot more.

     What I have done:

Go to layout [Invoices]

Go to record [First]


    Set Variable [$pdfnaam; Value: invoices::number & ".pdf"]
         Save Records as PDF [Restore; No dialog; "$pdfnaam"; Record being browsed]
         Send Mail [To: invoices::email; Subject: "some text"; Message "some message"; "$pdfnaam"]
         Go to Record [next, close after last]


     The e-mail is sent (I did a trial run) but no PDF attachment is sent with it. Can you help me figure out what I did wrong (and if this is indeed the method to do it?)

     Thanks, Femke