hi yvonne,

you can use the zope send mail method to pull data from a database.  the
problem
is with pulling in the text.  sendmail appears to send only literal
text, i.e., it does not parse html markup.  we are using a mysql
database to pull text and a second to pull names and emails, etc.  to
prevent the text from coming out as a single string, i have an external
python method that takes the string of text and writes out the lines as
lines of <= 75 chars, it also reinserts double line breaks,
as in between paragraphs.  

we use something like this:

you will need the MailHost product, and you will need to add a sendmail
method in your directory.  

ciao!
greg.

DBA/web programmer
venaca.com

***********************************************************************
 
<dtml-in get_prs>
  <dtml-call "REQUEST.set('z_subject', pr_subject)">
  <dtml-call "REQUEST.set('z_title',title)">
  <dtml-call "REQUEST.set('msg',pr_content)">

<dtml-in get_addresses>

<dtml-sendmail mailhost="MailHost"> 
To:  <dtml-var name> <<dtml-var email>>
From: <[EMAIL PROTECTED]>
Subject: <dtml-var z_subject>

<dtml-var z_title>

<dtml-in "clean_content(msg)">
<dtml-var sequence-item>
</dtml-in>
</dtml-sendmail>

</dtml-in>
</dtml-in>

"clean_content" is the name of the python external method.

This may not be ALL of the code, as i am really chopping some things out
of the actual dtml file for illustrative purposes.

a couple of warnings, in case you haven't used dtml sendmail.  you can
use nice indented tags within a <dtml-in> or <dtml-if> but not other
wise.  the left margin is, in my experience anyway, fairly inviolable.

as this is working now, if sendmail gets a bad address, it strangles
everything from the point of the error forward.  so, you should check to
make sure your emails are exactly correct -- i was doing a bulk mailing
of about 100 emails, and it died after the 6th one.

i don't know how to put in a trap into the method so that the mail
server catches the return mail but does not pass them to the zope
mailhost.  

ciao!
greg. 

> Yvonne Totty wrote:
> 
> Hi!
> 
> I need to send out mass mailings from time to time
> (newsletters, announcements and the such).
> 
> Is there an easy way to get this done? I already
> have the email addy's in the database.
> 
> TIA,
> Yvonne
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Yvonne Totty
> Database Engineer
> -------------------------
> Wolverine: You actually go outside in these things?
> Cyclops: Well, what would you prefer? Yellow spandex?
>

_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to