Bulk Email Report

ludydoo

Hi,

With fast report, I am generating a report that contains my clients states of account. Each report is separated by a page break.

I would like to enable my users to send generated states of accounts to multiple clients at once. I know fast-report has the option (with frxMailExport) to send a single report to an address. But I don't think the option to send multiple reports to multiple recipients is implemented.

Any idea on how to achieve this?

gpi

I think you should set TfrxPDFExport.PageNumbers and TfrxMailExport.Address properties

torkelmj

gpi wrote: »

I think you should set TfrxPDFExport.PageNumbers and TfrxMailExport.Address properties

?

I've got a similar issue.

My report contains a number of pages. Each page is relevant for one single customer only. I'd like to have each report page e-mailed as PDF attachment to a single customer. What's the best way to achieve this?

gpi

frxPDFExport1.PageNumbers := '1';
frxMailExport1.Address := 'address1@gmail.com';
frxReport1.Export(frxMailExport1);
frxPDFExport1.PageNumbers := '2';
frxMailExport1.Address := 'address2@gmail.com';
frxReport1.Export(frxMailExport1);

torkelmj

Thanks, gpi. The logic makes sense.

Part of the logic, then, will also be to keep track of what page number should be associated with which email address. Or is there a way to access a field's contents - say the field containing the email address - (in the report document) from within Delphi?

gpi

Create user function and call it to send start and end pages to Delphi from report

Bimmer_R

Having 5+ reports in its own tab of preview.

How to mail these reports as separate pdf in one email to a client?
So one email gets 5+ attachments.

Can this be solved with user function also?

gpi

Bimmer_R wrote: »

Having 5+ reports in its own tab of preview.

How to mail these reports as separate pdf in one email to a client?
So one email gets 5+ attachments.

Can this be solved with user function also?

Try to play with FileNames in the TfrxMailExport.OnSendMail. If this doesn't help - modify FR's sources