+ Reply to Thread
Results 1 to 2 of 2

can i link a date in excel to my calendar in outlook?

  1. #1
    jayne
    Guest

    can i link a date in excel to my calendar in outlook?

    I am setting up a spreadsheet, which includes a start date for a process and
    wonder if I can link this to an outlook Calendar so that it reminds me

  2. #2
    Registered User
    Join Date
    01-21-2006
    Posts
    1
    I create an Outlook Appointment on my calender with results from a userform to remind me to invoice service job.

    Hope this helps.

    With OutlookApp.CreateItem(olAppointmentItem)
    .Start = Date + 20 & " 2:00 pm"
    .End = Date + 20 & " 2:00 pm"
    .Subject = customer & " " & "Service Job #" & " " & TextBox1.Value & " ----> Invoice Due"
    .location = location.Value
    .Body = tbComment.Value
    .ReminderMinutesBeforeStart = 1440
    .ReminderSet = True
    .Save
    End With

+ 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