• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

Email checker

I am trying to create a program that will check for new email every 10 minutes,write the new email to an access database and then delete the message.  
The code I have does most of this except:

It will not check for new messages unless I log off and log on again.
Also it prompts me to select the profile every time, can this be done a automatically.


___Code____
Option Explicit
Dim ws As Workspace
Dim db As Database
Dim rs As Recordset

Private Sub Command5_Click()
MAPISession1.SignOff
Unload Me
End Sub

Private Sub Form_Load()
Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase("c:\vb\TASKS.MDB")
MAPISession1.SignOn
MAPIMessages1.SessionID = MAPISession1.SessionID
End Sub

Private Sub Timer1_Timer()
MAPIMessages1.FetchUnreadOnly = True
If MAPIMessages1.MsgCount > 0 Then
MAPIMessages1.Fetch
Label1.Caption = MAPIMessages1.MsgCount & " messages in que"
Set rs = db.OpenRecordset("tasks")
rs.AddNew
rs!Date = MAPIMessages1.MsgDateReceived
rs!From = MAPIMessages1.MsgOrigDisplayName
rs!email = MAPIMessages1.MsgOrigAddress
rs!subject = MAPIMessages1.MsgSubject
rs!message = MAPIMessages1.MsgNoteText
rs.Update
MAPIMessages1.Delete
'rs.Close
'Set rs = Nothing
Else
Label1 = ""
End If

End Sub

 
0
n_athen
Asked:
n_athen
1 Solution
 
AndrewDevCommented:


1)E-checker: Checks E-mail at Predefined Intervals
http://www.freevbcode.com/ShowCode.Asp?ID=1026

2)This is a calender that runs in the system tray you should be able to pinch the code that does that from it

Regards
Andrew
0
 
AndrewDevCommented:
0
 
n_athenAuthor Commented:
Thanks but I those programs are far to advanced for me.

Please ignore the request for system tray

I really just need to know what changes I need to make to my code that will have it check for new mail at a set interval.


thanks

0
 
DanRollinsCommented:
Hi n_athen,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:

    Accept AndrewDev's comment(s) as an answer.

n_athen, if you think your question was not answered at all or if you need help, you can simply post a new comment here.  Community Support moderators will follow up.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
Computer101Commented:
Comment from expert accepted as answer

Computer101
E-E Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now