Hi,

I've researched this question on quite a few sites, and was able to put together a few ideas, but I'm still having trouble. I'm hoping someone will be able to help me.

Here's the background of my project: I'm running Access 2007, but the database I have was created in an earlier version (2000 I believe). I am also running outlook 2007.

When a student is accepted into our program, we change their status from Applicant to Accepted (using options in a combobox). My supervisor asked me if I could add a field that would tell who referred the student. Then the first time the status was changed from Applicant to Accepted, an email notice would go to our program assistant, who would then notifiy the person referring the student that he/she was accepted.

I thought this would be much easier than it's turned out to be. I did some resarch and the only suggestion I could understand was to send the email using the SendObject command in VBA. However, every time I send the email the Outlook Security Warning that cautions me about a program trying to send email on my behalf pops up. When I click Allow the email is sent. The problem is, I don't know what to do about this warning.

I know very little about security, only enough to make me paranoid, and I don't want my database or my email account to become less secure by virtue of sending email programatically. I'm afraid to try to disable the warning because I don't know what consequences it could have for other things. I've heard of click yes, but I don't know if it's the best solution. I'm afraid of creating vulnerabilites because I don't think I know enough to see the big picture.

I also thought about making our program assistant's email into a hyperlink and sending the email that way, but I'm not sure if that would work. Is this a good idea? Could anyone please give me some advice? Thank you!