Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default Excel working in with Outlook

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.

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 140
Default Excel working in with Outlook

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

"Diamontina Cocktail" wrote:

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.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default Excel working in with Outlook

Thanks but you didn't provide the URL!

"steve_doc" wrote in message
...
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

"Diamontina Cocktail" wrote:

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.



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 140
Default Excel working in with Outlook

Ooops

Please accept my apologies - bad day at the office

Try
http://www.excelkb.com/?cNode=5V1C8G&pNodes=0U7Q0Q

HTH

"Diamontina Cocktail" wrote:

Thanks but you didn't provide the URL!

"steve_doc" wrote in message
...
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

"Diamontina Cocktail" wrote:

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.




  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default Excel working in with Outlook

HAHAA!! No worries. We all input a bad formula now and then! Thanks again.

"steve_doc" wrote in message
...
Ooops

Please accept my apologies - bad day at the office

Try
http://www.excelkb.com/?cNode=5V1C8G&pNodes=0U7Q0Q

HTH

"Diamontina Cocktail" wrote:

Thanks but you didn't provide the URL!

"steve_doc" wrote in message
...
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

"Diamontina Cocktail" wrote:

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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
custimized outlook today in outlook 2007 Hal Excel Discussion (Misc queries) 2 June 20th 07 12:59 AM
excel open in outlook if outlook is running kirk Excel Discussion (Misc queries) 0 May 24th 06 06:42 PM
Send to Outlook 2000 not Outlook Express Jimbo Excel Discussion (Misc queries) 2 January 4th 05 08:19 PM
Outlook 2003 demo back to Outlook XP Pete Carr Excel Discussion (Misc queries) 1 December 22nd 04 08:04 AM
Outlook with excel Pradeep Excel Worksheet Functions 0 November 1st 04 08:35 AM


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"