automatic start up???

[wendi_b]

Hi, does anybody know if it is possible to start up access automatically to do something and then close again?

I would like the db to check for dates in a table and if that date is today to send an email. If no one opens up the db then it won't do that...

Is that possible with access????

 

[Sergeant]

Haven't done this, but...
Use windows ControlPanel/ScheduledTasks to open the db. Make sure you set your macro security in Access to 'Low' to eliminate the need for user intervention. (Speaking of which, are you able to send emails from the db without user intervention?)

 

[wendi_b]

Yes, I can send emails without user intervention. I will try to do it the way you described, thanks.
Wendi

 

[namliam]

I would be intrested in that emailing, as now adays outlook requires user intervention for sending emails...

 

[Aviator]

I would be intrested in that emailing, as now adays outlook requires user intervention for sending emails...

had this problem a while back for someone and ended up using this

http://www.contextmagic.com/express-clickyes/

 

[namliam]

Nice to know, but not really an option for me....

 

[Sergeant]

RE: Circumventing Outlook security warnings...
I have used Outlook Redemption with good results. Also, if you have access to an SMTP server, that's another way to go.

Check out www.slipstick.com for further discussions on the subject.

 

[namliam]

To much reading to do,

Page bookmarked for future ref... Thanks

 

[wendi_b]

I have the on load event of the form that loads when the db starts up call the next function, you have to have the cdo file set as reference.

Public Function Email()

Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Example CDO Message"
objMessage.From = "example"
objMessage.To =strRecipient
objMessage.TextBody = "This is some sample message text."
objMessage.Send

End Function

The only problem I have now is to not make the db send it more than once.