Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Outlook reminders with excel worksheet

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-03-2009
Member
 
Join Date: Dec 2008
Posts: 94
Outlook reminder with excel worksheet
  

Hey Guys,

Does any one have any idea about how can i create reminders based on dates in a excel workbook? I would like to assign my workbook with dates to follow up with various assignments. I want my Outlook to open the Excel file showing me the dates and reminders for a particular assignment. Can any one guide me through that how can i do so? Any help on this would be appreciated.

Thanks.

Reply With Quote
  #2  
Old 06-03-2009
Member
 
Join Date: Sep 2005
Posts: 1,306
Re: Outlook reminders with excel worksheet

Open the workbook you wish to place the code in.Open the VBE (Visual Basic Editor) by pressing ALT+F11 keys.Insert a code module. Use the menus Insert and Module.Then simply paste the code.
Reply With Quote
  #3  
Old 06-03-2009
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: Outlook reminders with excel worksheet

You can use following vb code.

Visual basic code to create Outlook task with reminder.


Code:
Function AddOutLookTask()
         Dim appOutLook As Outlook.Application
         Dim taskOutLook As Outlook.TaskItem
         Set appOutLook = CreateObject("Outlook.Application")
         Set taskOutLook = appOutLook.CreateItem(olTaskItem)
      With taskOutLook
          .Subject = "This is the subject of my task"
          .Body = "This is the body of my task."
          .ReminderSet = True
          .ReminderTime = DateAdd("n", 2, Now)  ' Set to remind us 2
                                                ' minutes from now.
          .DueDate = DateAdd("n", 5, Now)       ' Set the due date to
                                                ' 5 minutes from now.
          .ReminderPlaySound = True
           'add the path to a .wav file on your computer.
          .ReminderSoundFile = "C:\Win95\media\ding.wav"
          .Save
      End With
     End Function
Hope so it may help you out.
Reply With Quote
  #4  
Old 06-03-2009
Member
 
Join Date: Apr 2008
Posts: 2,139
Re: Outlook reminders with excel worksheet

You can also follow the below steps.

1. "Dim StartingRow, RequestCount As Integer" - in VBA, this
translates to "Dim StartingRow As Variant, RequestCount As Integer"

If you are trying to declare both variables as integers, try "Dim
StartingRow As Integer, RequestCount As Integer". The same goes for
"Dim ExtractedAsset, ExtractedUser As String" I think you meant "Dim
ExtractedAsset As String, ExtractedUser As String"

In other words you can share the "Dim", but not the declaration part.

2. "Set myOlApp = CreateObject("Outlook.Application")"

You might want to check if you are already running Outlook, then you
can substitute this code to use the existing instance instead of
always starting a new one:

On Error Resume Next
Set myOlApp = GetObject(, "Outlook.Application")
If Err.Number <> 0 Then
Set myOlApp = CreateObject("Outlook.Application")
End If
On Error GoTo 0

If myOlApp Is Nothing Then
MsgBox "Could not start Outlook!"
Exit Sub
End If

Or, since you have a reference to the Outlook object library, "Set
myOlApp = New Outlook.Application". CreateObject & GetObject are
really for late-bound code. That being said, I use it all the time.

3. "StartingRow = Selection.Row"

You can eliminate this part of your code and fix the rest so that you
could run it in a loop on multiple rows. For example here is the
cleaned up code.
Reply With Quote
  #5  
Old 16-03-2011
Member
 
Join Date: Mar 2011
Posts: 1
Re: Outlook reminders with excel worksheet

Would there be a way to set this up for mulitple reminders. I need a reminder set for 20 mins, 2 hours, 3 hours, 4 days, and 5 days. These numbers are always constant.
Reply With Quote
  #6  
Old 17-03-2011
Member
 
Join Date: Dec 2007
Posts: 994
Re: Outlook reminders with excel worksheet

Quote:
Originally Posted by Jbea View Post
Would there be a way to set this up for mulitple reminders. I need a reminder set for 20 mins, 2 hours, 3 hours, 4 days, and 5 days. These numbers are always constant.
I think that you can't set multiple reminders but you can set a reminder then snooze it without any problems. To mass change the reminder time, add the remind beforehand field to All appointments view then group by it. Change 1 appointment to have a 2 day reminder then drag the others to that group. (You can grab a group header and drag the entire group.)
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Outlook reminders with excel worksheet"
Thread Thread Starter Forum Replies Last Post
Want to add a Excel Worksheet link on Outlook Message New!life MS Office Support 2 24-02-2012 12:14 PM
Clicking on Worksheet on multiple Worksheets in the single Excel file not allow viewing the worksheet in Microsoft Excel 2010 Dipanwita Windows Software 8 04-12-2011 11:24 AM
Outlook Reminders Popup not working in Windows 7 Pomona Windows Software 6 13-03-2011 09:54 AM
Disable Outlook calendar reminders joal123 Windows Software 4 25-03-2010 03:07 PM
Calendar Reminders in Outlook 2003 not working SinguIar MS Office Support 8 27-02-2009 03:05 AM


All times are GMT +5.5. The time now is 01:27 AM.