Sending an Outlook Appointment using MS Access

[JamesMerritt]

I am currently developing a database that handles broadband processing and registration of leads. I have a form where a user can request a 3-way call and i would like the form to send an outlook appointment to a group of users to book the request in.

I currently have had to resort to using the sendobject function and just send a rich text email, which relies on the user hitting the send button on the email.

Is there anything someone can suggested that will not only automate the email send but also send an appointment?

 

[kjv1611]

I'd guess you can use the MS Outlook xx Reference, and there would be tools in there for controlling Outlook. The only possible problem would come in with sending email to multiple recipients via VBA. At least the last time I looked into that, the method for doing so was sort of hampered by a new security update, due to people using the method for SPAM.

--

"If to err is human, then I must be some kind of human!" -Me