[NOTE:  Cross-posted to PLUG and PLUG Newbie Mailing Lists.]

Hello all,

I need some inputs and/or advice regarding Postfix.  My boss include me in a
project of the "E-mail Confirmation System" which will provide additional
service to all taxpayers who paid their taxes.  In this process, the
taxpayers will receive an e-mail confirming that their payment was recieved
by the BIR with the following contents/information:

- name of taxpayer
- taxpayer's TIN
- amount recieved
- date
- branch office/bank
- collecting officer's name/ID
- etc.

My idea on this is to create a small database for e-mails to suffice the
need for the said project.  This database will have at least two columns and
that would be the [1]e-mail address and the [2]TIN.  When our Bank and
Reconcialiation System receives the payment from a certain taxpayer, it will
send the above information to the e-mail database that we will create and
will send automatically a confirmation e-mail to the taxpayer that BIR has
received their payment.

Now my question is, how can I tell our e-mail database to tell our Postfix
to send a confirmation e-mail to the taxpayer's e-mail with the above
information?  My idea on this is that the trigger column will be the TIN.

My second and last question is, how can I filter the received e-mails from
the taxpayers and from bounced e-mails (considering the e-mail address is
wrong or doesn't exists) to the taxpayer's respective BIR regional and
district office?  There is only one e-mail address/account (probably it
would be [EMAIL PROTECTED]) for the outgoing e-mails but if the
[EMAIL PROTECTED] receives e-mail from the taxpayers or receives bounced
e-mails, it will be forwarded to the taxpayers' respective BIR
regional/district offices' e-mail address/account to answer if there's an
inquiry or to call the attention of the taxpayer if it was a bounced e-mail
to provide the correct e-mail address.

Please forgive my ignorance, I just don't have any idea with Postfix and MTA
in general.  Please give me some advice.

Thank you very much in advance.

God bless...

---
MARVIN T. PASCUAL
E-Mail: [EMAIL PROTECTED]
Tel. #: (+63-2) 925-2053/981-7068
Mobile #: (+62-919) 314-1254
Linux User No. 247147
BEGIN:VCARD
VERSION:2.1
N:Pascual;Marvin T.
FN:Marvin T. Pascual
ORG:Bureau of Internal Revenue;Information Systems Development Service
TITLE:Information Systems Analyst 1
TEL;WORK;VOICE:9252052
TEL;WORK;VOICE:9817022
TEL;HOME;VOICE:9293952
TEL;PREF:9252052
ADR;WORK:;Systems Maintenance and Support Division;#14 Makadios Street, Sikatuna Village;Quezon City;;1101;Philippines
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Systems Maintenance and Support Division=0D=0A#14 Makadios Street, Sikatuna =
Village=0D=0AQuezon City 1101=0D=0APhilippines
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20020423T181951Z
END:VCARD

Reply via email to