Hi Santosh,
it's not possible under my view.
however you can do this
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
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
On Sun, Mar 8, 2009 at 5:42 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hello All,
>
> Please help me with below mail it is very urgent.
>
> Regards
> Santosh
>
>
> On 3/1/09, santosh subudhi <santoshkumar.subu...@gmail.com> wrote:
>>
>> Hi All,
>>
>> I want to put some reminders in my excel sheet which we open regularly.
>> Suppose a pop up message box appear on a particular date stating" Hello
>> today is the birthday of your team memeber" or " need to send a mail to some
>> one".
>>
>> Regards
>> Santosh
>>
>
>
> >
>
--
Hari kumar
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
