borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (Small problem with a List box)Next Topic (Ideas needed) New Topic New Poll Post Reply
AndreaVB Forum : VB General : is export from Access to Outlook's calender possible?
Poster Message
Amiga2000
Level: Professor

Registered: 31-10-2002
Posts: 77

icon 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
View Profile Send Email to User Show All Posts | Quote Reply
CraigKirby
Level: Guest

icon 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."

    End If
    



[Edited by admin on 08-04-2004 at 08:09 AM GMT]

08-04-2004 at 06:46 AM
| Quote Reply
AndreaVB Forum : VB General : is export from Access to Outlook's calender possible?
Previous Topic (Small problem with a List box)Next Topic (Ideas needed) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder