Question about sending query data by email. !!!

65899182

The function I want to achieve is to execute the query statement regularly every day and send the query result to the user by email. Different users can set their own query conditions.

Some guys who have done similar things give some ideas !!!!!!

The biggest problem is how to query the data sent by email.

liuzhaoge

Save different users and their query conditions in the database. Make a console program, take query conditions, execute, get results, and send emails. The timing function can be run regularly with the Windows system tool Scheduled Tasks (it seems to be called scheduled tasks).

liuzhaoge

Schedule tasks to execute this console program regularly

xiaofen81

The biggest problem is how to send out the queried data via email.


You can create a dynamic page like this. After you take out the records from SQL (of course, don't take them all at once, take a part at a time), loop the record set, construct the URL according to the value of each record, and use a com component called winhttp , Visit the dynamic page just created, you can get the content of each record, and then you can use jmail or the system's own Mail to send it to the user's mailbox.

Until all records have been sent.

chensaizc

up