Send Outlook Tasks Automatically

[Myriad_Rocker]

First, I want to say that I have used the search feature A LOT all day today looking for answers. I also know of the security features in Outlook 2003 that don't allow you to utilize the Outlook Object Model in Access to truly automate tasks and emails.

Basically, I'm designing a system to where users will open a form in Access and fill out a service request that will be sent via Outlook to the IT Manager's task list. I want this to all be fully automated but while testing, I have found that you have to click Yes on the security warnings in Outlook.

I have read up on the ClickYes and Redemption things. For me, those aren't options. The company I work for will not allow me to install these things on the user machines.

So, what are my options? Can I get around this security thing somehow? I have read about CDO. I did a search to learn more and couldn't find anything that showed me some examples. I also read about SMTP but wasn't clear if I could use that to send Outlook Task items from Access with it...or how to implement it, for that matter.

Additionally, I read something about using SMTP in relation to tasks someone had posted and he/she mentioned using StoreID and EntryID. I searched on this here and in Google and couldn't really find any answers that made sense.

So...any suggestions?

 

[Myriad_Rocker]

bump...............

 

[evanscamman]

Redemption

You need Redemption.

I used to use the SendObject to send mail in Outlook, but the 2003 security made it too painful.

Download Redemption (search for it) and install it.
Works perfectly.

Evan

 

[Myriad_Rocker]

You need Redemption.

I used to use the SendObject to send mail in Outlook, but the 2003 security made it too painful.

Download Redemption (search for it) and install it.
Works perfectly.

Evan

And don't all machines that run the app have to have it? Like I said, I can't do that.

 

[evanscamman]

Sorry,
Typed too fast...

You probably are going to end up with CDO or SMTP then.

I don't understand much about either, but I did get SMTP to work at one point - it was just a littly weird when I had to provide my code with my personal email address and ISP to use to send the message from.
Perhaps the company you are working for has their own SMTP server that you can use.
But again, I don't know if what you send with SMTP will show up in Outlook.

I think CDO might be able to integrate with Outlook - but now I'm just guessing.

Evan