Johan, Member
Hi
When I use this code to send a report as pdf I get an error (send with 1 error). When i just mail the report as html it works fine. Any idea what's going wrong?
select 'dbr.mail';
select 'dbr.mail.attach','report.pdf','https://rapporten.xxx.nl/xxx/report.php?r=381&m=26&h=92cba4ba669f3cc8598f3d2a369132e43cdbaf5b&export=pdf';
select p.email, p.lastname, 'my report' from `10073`.users u inner join `10073`.person p on p.personid = u.personid where p.personid = 3;
Johan
myDBR Team, Key Master
Johan,
and the URL is valid and produces a PDF document?
If you are using SMTP, try enabling the debug option to see if there is additional info:
select 'dbr.mail.debug', 1;
--
myDBR Team
Johan, Member
Hi
The url is correct en produces a pdf document.
I don't get any additional info with mail.debug. I do not have acces on the settings of the server (Regas). It seems like only the html option is working. (select 'dbr.mail',1; )
Johan
myDBR Team, Key Master
Does the PDF attachment work if you are sending the mail as HTML?
--
myDBR Team
Johan, Member
No it's not working but I can sent a HTML mail using record.
Johan
myDBR Team, Key Master
Were you using SMTP sending? What did the debug log show? Did you see the attachment there bening generated?
--
myDBR Team
Johan, Member
Ok found the solution.
I forgot to add some bodytext in my mail.
Johan
You must log in to post.