Generating multiple emails from report

rbuser

Hi,

Is it possible to split a report into multiple emails when I choose to email
a report?
The case is that we have a form letter. Using mail merge we can print nice
mailings.
We would like to email this mailing using personalized data.

I tried to use section subreports but this didn't work.

Using RB 10.06 Ent, D7.

Regards,
Jeroen R?ttink

nicocizik

Hi Jeroen,

There is no built-in feature to send multiple emails for a single report.

Ideally you would want to create a loop that changes the search parameters
for your connected dataset and then calls Report.SendMail (with altered
Emailsettings) for each email you need to send.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

But that's quite difficult. The report uses DADE dataview linking and the
result set is defined by some time interval and some other search fields. No
simple search parameters on a primary key.
To get it working like you said, I have to use a select FIRST 1 SKIP n
construct, loosing all DADE dataview linking. To be correct this should be
executed in 1 transaction.
Can't something be done with a section subreport because such a subreport
can now already be printed as a separate printjob? Separate printjob -->
separate email?

Regards,
Jeroen.

nicocizik

Hi Jeroen,

In order to implement your idea below, it would be necessary to be able to
print a child report to PDF because you would need to call SendMail for each
Section subreport that is printed. Calling SendMail creates a PDF device by
default and exports the calling report. Calling SendMail from a child
report however will not produce a valid PDF.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com