mas7357
Posts: 29
|
| Posted: 11/04/2006, 10:50 AM |
|
A quicky,
Has anybody been able to define an E-mail distribution list from table entries. If so I would really like to hear from you
_________________
MikeS |
 |
 |
TheunisP
Posts: 342
|
| Posted: 11/10/2006, 3:28 PM |
|
I did a nasty work around by outputting a grid and in the before show event doing an e-mail sent - not very effective for large lists but in a very small environment works just give it a large page size
as said not a very nice one - but would love to share ideas - I need a mass emailer solution - and has been putting it off
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/11/2006, 12:00 AM |
|
I've seen this done a lot of times. You can just write a short "send_email" function that loops through records and sends emails. This is not CCS specific, so any example from the Internet should work. Here is just one:
http://www.paulsadowski.com/WSH/cdo.htm
SQLQuery = "SELECT Name, Email FROM Customers"
Set Result = OBJdbConnection.Execute(SQLQuery)
if Not Result.EOF then
Do While Not Result.EOF
SendMail Result("Name"), Result("Email")
Result.MoveNext
Loop
end if
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
