UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Email One Customer With Multiple Estimates, 2016    
 
   
pkraja
post Aug 1 2016, 04:25 PM
Post#1



Posts: 1
Joined: 13-October 15



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.
Attached File(s)
Attached File  pkraja_1.zip ( 17.51K )Number of downloads: 4
 
Go to the top of the page
 
MadPiet
post Aug 1 2016, 05:46 PM
Post#2



Posts: 2,255
Joined: 27-February 09



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.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 03:08 AM