Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Products: CMS Builder: Plugins & Add-ons:
Email Plugin

 
 


nmsinc
User

Aug 30, 2011, 4:11 PM

Post #1 of 6 (5477 views)
Shortcut
Email Plugin Can't Post
Using CMS 2.11



I have two databases, each with multiple contact email addresses for each record saved. The first is for an Insurance Company, which includes name, address and several email contacts. The second is the agent database, which contains the Agent’s name, address and several email contacts.



These two databases are used to populate a third database by choosing the Insurance Company name and the Agent’s name.



I’m looking for a plug-in that will send an email to the email addresses within the records used to populate the third database when a record is saved or updated!



I checked out the “AlertRecordSaved” plug-in by Djulia and it only emails the admin and does not allow for easy setup of secondary email communications.



Any suggestions?



Thanks

Ray




Djulia
User

Aug 31, 2011, 1:28 AM

Post #2 of 6 (5462 views)
Shortcut
Re: [nmsinc] Email Plugin [In reply to] Can't Post
Hi,

> I checked out the “AlertRecordSaved” plug-in by Djulia and it only emails the admin and does not allow for easy setup of secondary email communications.
You can perhaps use bcc ?
'bcc' => Your email.

Djulia


(This post was edited by Djulia on Sep 8, 2011, 11:43 PM)


nmsinc
User

Aug 31, 2011, 11:09 AM

Post #3 of 6 (5426 views)
Shortcut
Re: [Djulia] Email Plugin [In reply to] Can't Post
Hi Djulia,



Two questions:



I’m looking over the code for your plug-in – can the user open multiple tables on line 18?



Also, I propagate a third database table using information from two others by choosing the name of an Insurance Co. from one and the name of the agent from the other. Each of the other two tables contains multiple emails that need to propagate based on the my choice from the other two tables to your plug-in which are not part of the third database table. Can you suggest a set of code to handle this?



Thanks


Djulia
User

Aug 31, 2011, 12:53 PM

Post #4 of 6 (5414 views)
Shortcut
Re: [nmsinc] Email Plugin [In reply to] Can't Post
Hi nmsinc,

I think that you can use a condition on the name of the tables (line 19) :

if ($tableName == 'table3') { your function mail with request sql and other functions }
if ($tableName == 'table2') { your function mail and other functions }
if ($tableName == 'table1') { your function mail by default }

Djulia


danwilson
User

Sep 8, 2011, 7:18 PM

Post #5 of 6 (4746 views)
Shortcut
Re: [Djulia] Email Plugin [In reply to] Can't Post
(Did you mean "bcc" instead of "bbc"?)


Djulia
User

Sep 8, 2011, 11:44 PM

Post #6 of 6 (4729 views)
Shortcut
Re: [danwilson] Email Plugin [In reply to] Can't Post
Oops ! Thanks ! :)