We need a program to send mail.
We have some files (pdf and xls) that we have to send to many recipients according to a schedulle.
We will have a table (maybe Access¿?) with the fields:
Type (this is "To", Cc" or "Bcc"
Week_day_1 (this is a yes/no field)
So you have to find the week day for today, filter the list to get the records with "yes" for that week_day. Find the file, put it in a mail and send.
We will use a pop3 account.
If you will use Outlook, the I don't want to have security issues...
Should run in Windows XP or later or server.
The subject and body will be something like "Attach you have the last report: &file name&"
Finally I need a log to track history.