I am using ASPRunnerPro 5.2 (Buld 423). I am on my final phase of completing a project at hand. The project is to construct a contact management database.
We are migrating from a horrific contact management application (Act! for Web 2007) to this newly built database. Our old software provided web-based access, which we loved the idea of, but it seldom worked.
I have constructed a custom project (not using a template) on MS Access. I have created all of my tables pertinant to the project. One of these tables is for storing contact information - name, email, address, ... , and also yes/no fields to classify conacts based on their particular involvements with our organization. The database as it stands is operating flawlessly. My last phase of completing this project is to implement a page for emailing (SMTP) contacts based on those yes/no classifications as listed above - basically the equivilent of sending to a group name where all contacts who are part of that group receive the email. Sometimes people will be part of more than one group and if possible, I would like to supress duplicate emails they would potentially receive because of that. In case you question why I have not set up each group as it's own table, there are reasons for that - but that's another story.
What I am visualizing is....
To: have a list of check boxes of the classifications of the contacts and check off all boxes relevant to the particular email I am sending.
Subject: It would be necessary to provide a custom subject each time, not a predefined subject embedded in the code
Message: An HTML editor (WYSIWYG)
Attachement(s): The capability of sending at least one attachment with these emails would be great now, and definitely necessary at a later time. I know a folder with write permissions or something would be needed here and I don't care if the uploads remain on the server after the email is sent. I need them for archiving purposes later anyway.
I have been browsing through articles in the forums for the past 5-6 days and have found vague similarities in some of the scenarios, but nothing that would give me an idea how to build this up into exactly what I need it to do.
I know what I've described is possible, but getting a start on it is where I need help. Once I get the basic framework I'm good to go. I also realize this will take some time, so what better time to get going on it than now. Whatever insights you (anyone) can provide would be better than what I have now. I just have a bunch of notes and possibilities scribbled out on paper so I can get a visual on it. I do have time constrictions for this as we have an urgent need to break away from the current software we utilize. As I mentioned, it has it's fair share of problems and we are currently unable to have a decent workflow without something crashing every time.
Thanks,
Garrett