Amiga2000 Level: Professor Registered: 31-10-2002 Posts: 77
is export from Access to Outlook's calender possible?
Is it possible to export data from MS Access to MS Outlook's Calender using VB ?
Regards,
John
13-02-2003 at 11:51 AM
|
CraigKirby Level: Guest
Re: is export from Access to Outlook's calender possible?
i dont have outlook on my system anymore so i cant be more specific but...
i got the todo list from outlook into access with this VBA written in access
i know it isnt what you want but it should be possible to create a user control in vb for outlook that gets data from access using something similar
hope this helps in some way
-craig
'Lists reminder caption information
Dim olApp As Outlook.Application
Dim objRem As Reminder
Dim objRems As Reminders
Dim strTitle As String
Dim strReport As String
Set olApp = Outlook.Application
Set objRems = olApp.Reminders
strTitle = "Current Reminders:"
'If there are reminders, display message
If olApp.Reminders.Count <> 0 Then
For Each objRem In objRems
'If string is empty, create new string
If strReport = "" Then
strReport = objRem.OriginalReminderDate & " - " & objRem.Caption & vbCr
Else
'Add info to string
strReport = strReport & objRem.OriginalReminderDate & " - " & objRem.Caption & vbCr
End If
Next objRem
'Display report in dialog
MsgBox strTitle & vbCr & vbCr & strReport
Else
MsgBox "There are no reminders in the collection."