Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ BI Tools and Applications _ Email One Customer With Multiple Estimates

Posted by: pkraja Aug 1 2016, 04:25 PM

Hi - I have a table that lists customers who have not approved an estimate. Within each estimate is a list of parts needed for the repair. What I would like to do is to send an email to each customer with their Estimate Number, Parts Used, Line Item Total, and Estimate Total. My issue is that I have a single customers with multiple estimates which in turn have multiple parts. I would like to send one email to each customer list all of the details as opposed to multiple emails to a single customer.

Here is a snippet of my table
RMA Contact Customer Email Manufacturer Model Serial Estimate Quantity Part Description Amount
QM53922 John Breckenridge John@xyz.com Airsep Intensity N0215064 250 1 AR-Flat-Rate-OS Airsep Concentrator Flat Rate 250
QM53925 John Breckenridge John@xyz.com Airsep Elite 261005 215 1 AR-Flat-Rate-OS Airsep Concentrator Flat Rate 215
QM56863 John Breckenridge John@xyz.com Devilbiss 7305 PD430432 70 1 SC-5533 Battery, Devilbiss Suction 0
QM56863 John Breckenridge John@xyz.com Devilbiss 7305 PD430432 70 1 SC-Service Service, Suction 70

Any help would bee appreciated.

 pkraja_1.zip ( 17.51K ): 5
 

Posted by: MadPiet Aug 1 2016, 05:46 PM

Create a report with all the data in it that you want to e-mail. (might have subreports). Then create a unique list of recipients, loop through that, and e-mail them using SendObject maybe.