[ic] using IC to send out newsletter -automatically
Jeannie Stevenson
webteam at wes-state.com
Tue May 11 17:22:04 EDT 2004
Hello list
My client want to use IC to send out html/text newsletter using the IC cron
method
In catalog.cfg I have:
Jobs base_directory etc/jobs
Jobs log log/cron.log
Jobs email my-email-address
In etc/jobs/job1 I have:
#!/bin/sh
[query list=1
sql="select username, password, fname, lname, email, mail_list
from userdb where mail_list like '%newsletter%']
cat <<EOF | sendmail -t
From: Wes-State Mortgage, Inc <service at wes-state.com>
To: [loop-pos 3] [loop-pos 4] <[loop-pos 5]>
Subject: wes-state mortgage,inc. newsletter
extra=|
[tag op=mime arg=header][/tag]
|]
[tag mime boundary][/tag]--
<body>
[include include/newsletter/newsletter6]
</body>
Best Regards,
Wes State Mortgage, Inc. Customer Service
Note. You subscribed to this list (newsletter) when you either visited
or placed an order with us. you can unsubscribe at any time with the
following
url:
{mv_base_url}list=newsletter&what=[loop-pos 5]&who[loop-pos 0]
Thanks for your business
EOF
[/query]
It should query the database for newsletter out of the userdb mail_list
column, inserts the html file within the <body></body> tags and then send an
email to those individualls but nothing seems to be happening.
I've executed the batch as user interch with:
/var/local/interchange/bin/interchange --runjobs=wes-state=job1
Any thoughts, ideas, or pointers would be helpful
Thanks Jeannie
More information about the interchange-users
mailing list