Save task

Status
Not open for further replies.
M

Marc

Hi,

This is my requirement, when I save a task in MSOutlook

It should run my own macro to do a process.

How do I call my macro when saving a task.

Pls help..
 
K

Ken Slovak - [MVP - Outlook]

Assuming the task has been opened, you get a handle to the item from the

Inspectors.NewInspector() event by using Inspector.CurrentItem. In this case

that would be a TaskItem. You then handle the item.Close() or

Inspector.Close() event for that item and call your code there.

"Marc" <dummy@abcd.com> wrote in message

news:u3vQqvuHKHA.3736@TK2MSFTNGP04.phx.gbl...
> Hi,
> This is my requirement, when I save a task in MSOutlook
> It should run my own macro to do a process.
> How do I call my macro when saving a task.
> Pls help..
>
 
M

Marc

Thanks Ken

But I added a macro like this

Public WithEvents myOlItems As Outlook.Items

Private Sub Application_Startup()

Call Initialize_handler

End Sub

Public Sub Initialize_handler()

Set myOlItems =

Application.GetNamespace("MAPI").GetDefaultFolder(13).Items

End Sub

Private Sub myOlItems_ItemAdd(ByVal Item As Object)

MsgBox ("New Task Added..")

End Sub

Is this correct??
<kenslovak@mvps.org> wrote in message

news:OhJxtA0HKHA.1492@TK2MSFTNGP03.phx.gbl...
> Assuming the task has been opened, you get a handle to the item from the
> Inspectors.NewInspector() event by using Inspector.CurrentItem. In this
> case that would be a TaskItem. You then handle the item.Close() or
> Inspector.Close() event for that item and call your code there.

> >

>

> "Marc" <dummy@abcd.com> wrote in message
> news:u3vQqvuHKHA.3736@TK2MSFTNGP04.phx.gbl...
> > Hi,
> > This is my requirement, when I save a task in MSOutlook
> > It should run my own macro to do a process.
> > How do I call my macro when saving a task.
> > Pls help..
> >

>
 
K

Ken Slovak - [MVP - Outlook]

That looks OK.

"Marc" <dummy@abcd.com> wrote in message

news:%23I16JT7HKHA.5956@TK2MSFTNGP03.phx.gbl...
> Thanks Ken
> But I added a macro like this

> Public WithEvents myOlItems As Outlook.Items

> Private Sub Application_Startup()
> Call Initialize_handler
> End Sub

> Public Sub Initialize_handler()
> Set myOlItems =
> Application.GetNamespace("MAPI").GetDefaultFolder(13).Items
> End Sub

> Private Sub myOlItems_ItemAdd(ByVal Item As Object)
> MsgBox ("New Task Added..")
> End Sub

> Is this correct??
 
M

Marc

How do I install a Macro

in to another user's machine in secured way.
<kenslovak@mvps.org> wrote in message

news:OyD$APAIKHA.4376@TK2MSFTNGP03.phx.gbl...
> That looks OK.

> >

>

> "Marc" <dummy@abcd.com> wrote in message
> news:%23I16JT7HKHA.5956@TK2MSFTNGP03.phx.gbl...
> > Thanks Ken
> > But I added a macro like this
>

>> Public WithEvents myOlItems As Outlook.Items
>

>> Private Sub Application_Startup()
> > Call Initialize_handler
> > End Sub
>

>> Public Sub Initialize_handler()
> > Set myOlItems =
> > Application.GetNamespace("MAPI").GetDefaultFolder(13).Items
> > End Sub
>

>> Private Sub myOlItems_ItemAdd(ByVal Item As Object)
> > MsgBox ("New Task Added..")
> > End Sub
>

>> Is this correct??

>
 
K

Ken Slovak - [MVP - Outlook]

For deployment, the best practice is not to use VBA code but to use COM

addins. See http://www.outlookcode.com/article.aspx?id=28.

"Marc" <dummy@abcd.com> wrote in message

news:%23vK6qUAIKHA.5956@TK2MSFTNGP03.phx.gbl...
> How do I install a Macro
> in to another user's machine in secured way.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
B Task macro to save task into specific folder Outlook VBA and Custom Forms 1
D Updating Registry to force new task and note items to save in a particular folder Using Outlook 1
F Outlook 2010 custom font style duplicates itself every time I save a task Using Outlook 0
D VBA Macro to Print and Save email to network location Outlook VBA and Custom Forms 1
N VBA Macro To Save Emails Outlook VBA and Custom Forms 1
N Save emails within a certain date range to network drive Outlook VBA and Custom Forms 0
T Outlook 365 Move newly created tasks automatically on save. Outlook VBA and Custom Forms 1
G Save attachment run a script rule Outlook VBA and Custom Forms 0
N Save Selected Email Message as .msg File Outlook VBA and Custom Forms 12
G Save and Rename Outlook Email Attachments Outlook VBA and Custom Forms 0
G VBA to save selected Outlook msg with new name in selected network Windows folder Outlook VBA and Custom Forms 1
D Outlook 2016 64bit, Cannot Save in 'HTML', format Using Outlook 1
N Save selected messages VBA does not save replies and/or messages that contain : in subject Outlook VBA and Custom Forms 1
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 17
S save attachment with date & time mentioned inside the file Outlook VBA and Custom Forms 0
S Add VBA save code Using Outlook 0
A Edit attachment Save and Reply Outlook VBA and Custom Forms 0
S Outlook (2016 32bit; Gmail IMAP) - Save sent message to Outllook Folder Outlook VBA and Custom Forms 0
P Outlook pst file is too huge with POP3. How to save more space? Using Outlook 4
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 2
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
M Outlook 2013 Script Assistance - Save Opened Link with Subject Added Outlook VBA and Custom Forms 1
R Use an ItemAdd to Save Attachments on Arrival Outlook VBA and Custom Forms 0
W Outlook Calendar does not save view any longer! Using Outlook 3
S automate save the .xlxs file to share Network Using Outlook 1
S save email from excel Outlook VBA and Custom Forms 1
Y Open and Save Hyperlink Files in multiple emails Outlook VBA and Custom Forms 9
9 Outlook 2016 How to save an Outlook attachment to a specific folder then delete the email it came from? Using Outlook 1
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
R VBA | Chosing path to save file Outlook VBA and Custom Forms 1
W Save and rename outlook email attachments to include domain name & date received Outlook VBA and Custom Forms 4
V Change default default save location to Quick Access Using Outlook 1
W Save Outlook attachment in network folder and rename to current date and time Outlook VBA and Custom Forms 18
C Change default "Save Sent Item To" folder Outlook VBA and Custom Forms 9
C Outlook - cannot save subject line changes Using Outlook 2
J Save E-mail attachments in a specific folder Outlook VBA and Custom Forms 0
I Outlook 2016 64bit - on receipt convert emails into PDF and save Outlook VBA and Custom Forms 2
V VB script code to save a specific email attachment from a given email Outlook VBA and Custom Forms 14
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
N editing drafts - won't let me save Using Outlook 12
nathandavies Email Details to Excel & Save as .MSG on one macro - combination of 2 macros Outlook VBA and Custom Forms 3
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
D Save Sent Item to Using Outlook 0
Diane Poremsky Save Selected Email Message as .msg File Using Outlook 11
Diane Poremsky Export (Save) Outlook Contact photos Using Outlook 0
Diane Poremsky Save Messages and Attachments to a New Folder Using Outlook 0
B Delete/replace old files and save new attachments Using Outlook 1
E Outlook 2016 and Numerous Prompts to Save Emails Using Outlook 3

Similar threads

Top