Thank you freez very good tutorial :)Quote:
You will need to either program this using a stored procedure in SQL or in another language. either way you need to program it.
You need to capture the character number from the character table. So a query and loop around the results. In the loop, execute the SP_POST_SEND_OP stored procedure and put in the character number, subject, message, item index number.
Save your stored procedure and set a job to run it every 15 minutes etc. Right-click jobs under sql server agent and select new job. Give it a name, create the steps to run the stored procedure, set the schedule and you're done!
I haven't seen any scripts here that are pre-made that do this but this is an easy way to make an automated task without a lot of programming knowledge.