+ Reply to Thread
Results 1 to 2 of 2

Need help to create Excel macro for Outlook Reminder

  1. #1
    Registered User
    Join Date
    04-12-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Need help to create Excel macro for Outlook Reminder

    Hi,

    I'm no developper and I try to create a macro in Excel 2003 to create an Outlook Reminder for an user to update a workbook on a periodical basis (determined according to a value in the workbook). I have been able to figure the following coding:

    Sub CreateAppointment()
    Dim olapp As Outlook.Application
    Dim olappItem As Outlook.AppointmentItem

    Set olapp = GetObject("", "Outlook.Application")
    Set olappItem = olapp.CreateItem(olAppointmentItem)
    With olappItem
    .Start = Range("'Out_App'!A6").Value
    .Subject = Range("'Out_App'!B6").Value
    .Duration = 1
    .ReminderSet = True
    .Save
    End With
    End Sub

    However, when I run the macro, I receive the following error message: "User-Defined Type Not Defined" and nothing happens.

    Could you please help me with this task?

    Thanks

    Eric

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Need help to create Excel macro for Outlook Reminder

    In the VBA Editor go to Tools References and find Microsoft 11.0 Object Library in the list and enable it.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1