Solved

Can Excel trigger actions on a task in Outlook?

Posted on 2011-03-07
4
287 Views
Last Modified: 2012-05-11
I have an Excel spreadsheet in which the user creates goals, projects and tasks for the purpose of staying organized.

I have a friend who is using it and he has actually used Outlook for task management.  He's asked me if the spreadsheet he's now using could be integrated with Outlook so that he could manage tasks from either application.

I don't know the details of exactly what he's hoping for, but I thought I'd lob the general question out for feedback.

What else do you need to know to answer the question?  Are there limitations that might be deal breakers for usability?

FYI, the spreadsheet does include a significant amount of VBA, conditional formatting, Data validation and such.

Thanks, Jim
0
Comment
Question by:coachjim
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 2

Assisted Solution

by:GaGirrl
GaGirrl earned 20 total points
ID: 35061876
Not sure if this is what you're looking for, but you can launch a command in Excel to execute an Outlook task.

Create Outlook task for workbook

You can add the "Create Microsoft Outlook Task" option to the ribbon (if you're using Office 2007). Once you launch that option, it opens an Outlook task and you see your Excel sheet embedded within it.

Not sure how much "managing" occurs between the applications, but you can at least link an Outlook task to the Excel workbook.
0
 
LVL 22

Assisted Solution

by:rspahitz
rspahitz earned 20 total points
ID: 35061882
This is totally do-able, but not necessarily an easy task.
Coding in Excel to add macros, etc is not bad since there's a wizard to help create it.  That wizard is not there in Outlook so experts need to know a lot more about the inner workings of Outlook through experimentation and other kinds of research.

However, simply things like getting Excel to open Outlook is not bad.  Getting the two to interact dynamically from either side requires a lot of synchronization and one has to control the other for it to work (although it can be made to look seamless if done right.
0
 
LVL 6

Accepted Solution

by:
royhsiao earned 85 total points
ID: 35063121
Here is an example.
You need to add the Outlook 12.0 Object library to the excel in reference.
You could update the body, due date, assign ...etc by using range value.

' Note: You must first manually bind the Outlook
' 12.0 Object Library by going to Tool,
' References in the VBA editor
''updated by Roy Hsiao 3/7/11
Sub test()
   Set olApp = CreateObject("Outlook.Application")
   Set olTsk = olApp.CreateItem(olTaskItem)
   With olTsk
       .Status = olTaskInProgress
       .Importance = olImportanceHigh
       .Body = "Test body"
       .Assign = "Test!"
       .Owner = "Roy Hsaio"
       .DueDate = "12/25/11"
       .Save
   End With
   Application.ScreenUpdating = True
   Application.ScreenUpdating = False
   Set olTsk = Nothing
   Set olApp = Nothing
End Sub

Open in new window

0
 
LVL 2

Author Closing Comment

by:coachjim
ID: 35110699
All I was asking for was a sense of what was possible.  Next step is to see if someone can help me do it.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question