Search : in
By :

Create outlook reminders with excel worksheet

Last answer on Oct 14, 2009 6:02:11 pm BST smd, on Jan 31, 2009 8:43:28 am GMT 
 Report this message to moderators

Hello,
i would like to create reminders based on dates in a excel workbook. there is an excel workbook with dates to follow up various assignements. when i open outlook...the macro should should open the excel file run through the dates and add reminders for that particular assignment

example
excel workbook will contain
type descirption complete_by
client insurance card 15feb08

when outlook is started say on the 10feb..the macro should check the excel workbook and add a reminder in outlook for that particular row item which is to be completed on the 15feb.

thanks
smd

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « create outlook reminders with excel worksheet » in :
Import contacts from Excel to Outlook Show Import contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Using Excel in Outlook Show
How to create a clickable button and macro in Show
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
[Outlook Express] Create letter paper / Insert background image Show[Outlook Express] Create letter paper / Insert background image The letter paper is an Outlook Express feature allowing sending emails with illustrations (images, text, etc.) as background. Creating letterhead under Outlook Express In the...
Creating a signature for (Outlook/Thunderbird) ShowCreating a signature for (Outlook/Thunderbird) Create a signature under Microsoft Outook Create a signature under Thunderbird Messaging software such as Outlook and Thunderbird allow you to stick a signature to your messages. This...
Download Excel Password Recovery Master Show
Download Talking Secretary Show
Download Removable Media Undelete Tool ShowRemovable Media Undelete Tool is a data recovery utility to find Microsoft Office documents that you have removed accidentally or not. You can restore documents created with Word, Excel, Access or PowerPoint. It provides easy and step by step...
Creating a local area network ShowWhy set up a local area network? When you have several computers, it can be convenient to connect them to each other to create a local area network (LAN). Setting up such a network costs very little, contrary to what people may think. Here are a...
Hyperlinks ShowIntroduction to anchors Hypertext links or hyperlinks (anchors) are HTML elements that, when clicked on, enable readers to visit a new address. Hyperlinked text is underlined by default. Hyperlinks are what connect web pages to one another. They...
Creating a LAN ShowWhy set up a LAN? If you have several computers, it may be worthwhile to connect them in order to create a local area network (LAN). Setting up such a network is much less expensive than what you might think. Here are a few ways you might benefit...
Ask your question Reply

1

mailpcoff, on Jan 31, 2009 9:51:50 am GMT
  • +4

Hi,
try these:

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 it helps you.
good luck!

   
Reply to mailpcoff

2

xyberz, on Feb 3, 2009 9:13:04 am GMT
  • +5

Where are you supposed to input all that coding? It doesn't look like a macro.

   
Reply to xyberz

3

bla, on Mar 5, 2009 12:31:03 pm GMT
  • +4

Hi,

You have mentioned this macro coding below, where do you create this macro and how do u execute the same each time, have you tried this code? I want to connect dates in excel to a reminder in Outlook Express.

Can you help out.

Thanks

Blaise

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

   
Reply to bla

4

sedrok, on Aug 31, 2009 12:43:03 pm BST

Oh, I figured out how this procedure can be used!
Outlook .OnTime method Solution:

Private Sub Application_Reminder(ByVal Item As Object)
Item.Delete
' Tasks to do
AddOutLookTask
end sub

Public Sub 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("yyyy", 15, Now) ' Set the due date to
' 15 years from now.
.ReminderPlaySound = False
'add the path to a .wav file on your computer.
'.ReminderSoundFile = "C:\Win95\media\ding.wav"
.Save
End With
End Sub

   
Reply to sedrok

5

Manish, on Sep 10, 2009 10:02:51 am BST

I have same requirement.
So you mean to say all this code has to be entered in Excel Macro???
When I tried it gave me error "User Defined type not Defined" in line
Dim appOutLook As Outlook.Application
I tried to search i couldn't find "outlook" after As... ...

So can you help me where's the problem?

Regards,
Manish Bhatt

   
Reply to Manish

6

sedrok, on Sep 10, 2009 6:48:21 pm BST
  • +1

This vba code for Outlook 2003.

Press Alt + F11
Then in ThisOutlookSession copy this code.

   
Reply to sedrok

7

 Lazarus, on Oct 14, 2009 6:02:11 pm BST
  • +1

How can I upgrade this code in order to assign tasks to other people. Lets say I have a column which contains the name (or user ID) and after importing the file, Outlook would scan the column with user IDs and assign tasks to the people whos name is in the column.

Thanks,

   
Reply to Lazarus
Ask your question Reply
They need your help