Excel working in with Outlook

  • Thread starter Thread starter Diamontina Cocktail
  • Start date Start date
D

Diamontina Cocktail

I have Office 2007 so obviously Outlook 2007 and Excel 2007.

I have made up a newbie's Excel spreadsheet for my business. One thing to
open that has my entire financial year's data in it and my car logbook. One
thing I am going to add to it is parts. I want to know when parts need to be
re-ordered so will set a level where I want Excel to show up basically
something like a "reorder now" warning. However, I am often in a hurry,
record the event and don't look at the outcome until I have some time, late
at night. At that time, reordering becomes a nightmare.

Is there any way that Excel can do that kind of warning and work in with
Outlook so it throws up in my "To Do" list automatically? Any help
appreciated.
 
Hi

Having created a few applications that access either Outlook or Lotus Notes.
This is possible, having said that I have yet had to work with the tasks
list, so sadly at this stage cannot provide specific advise on "How To"

Excel will still require a "Trigger" to fire the events, whether that is the
workbook open event or some such.

The following site has some info on automating Outlook, and should give you
the basics to begin with. From there it just takes a little research into
Outlooks object model, and trying different ways.

HTH
 
Thanks but you didn't provide the URL!

steve_doc said:
Hi

Having created a few applications that access either Outlook or Lotus
Notes.
This is possible, having said that I have yet had to work with the tasks
list, so sadly at this stage cannot provide specific advise on "How To"

Excel will still require a "Trigger" to fire the events, whether that is
the
workbook open event or some such.

The following site has some info on automating Outlook, and should give
you
the basics to begin with. From there it just takes a little research into
Outlooks object model, and trying different ways.

HTH
Click to expand...
 
Back
Top