Can i use outlook and excel to work together?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel spreadsheet in which i'm using as an invoice template. One of
the fields of input is a schedule date with time and date. I am also using
Outlook's calender as my appointment tracker. What I'm trying to do is write
in a formula or a small macro that would let me type in the time and date on
the invoice in excel and then have it cross reference with my calender and if
there is a problem with that i want some kind of notification, either thru
the program or user defined. any suggestions?
 
You'll need to learn some Outlook automation techniquews. You might start with http://www.outlookcode.com/d/finddate.htm, which shows how to return items in a certain date range.

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crossing the International Date Line 1
Auto Change Formulas - Please Help. 2
Triggering an Outlook alert from a date on an Excel Spreadsheet 1
invoice from appointments 2
Outlook and Excel 1
outlook calendar appointments post to wrong date 1
Wish to have weekday name together with the date 2
Windows mail TO OUTLOOK 2003 4

Back
Top