Please How Can I use Vb and outlook....

• • Reply

  14 years ago

  by akidi

  Man

  , Guatemala

  Joined 14 years ago

  Specification (draft)
  
   1)
   To calculate a running total of flexible working hours and show it in
  calendar view based on a reference calendar which is on server in
  "Public Folders" with a name "Standard Working Hours"
   
   A separate "balance ticket" can be generated as well and user may open
  the balance ticket to get all the required information (daily and running
  balance). Runnig total and the updating of changed data may be a bit
  challenging to program !
   
   Another option is to place the information in the "Tasks" folder of
  the user or some other special "Own Working Hours"
   
   2)
   To calculate own daily working hours based on a reference calendar
  which is on server in "Public Folders" with a name "Working Hours"
   
   3)
   To check that there are no overlapping hours (overlapping
  appointments are OK, but the ones starting with an integer are not permitted to
  overlap). A RED error ticket may be generated or some other form of error
  message should be displayed to the user in error condition.
   
   4)
   TO make a balance correction - if needed based on special "balance
  correction" appoinment on the day given for the future days
   
   5)
   To produce a (given time span) report of used working hours to
  specific codenumber or task. This is extra bonus feature.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

   

   

  Please any help(snippets,codes,guides) would be greatly appreciated.
   
   
  
  

  Report abuse
• • Reply

  14 years ago

  by Trilarian

  Trilarian

  New Orleans, United States

  Joined 15 years ago

  Hi Akidi,
  

  I am just making a friendly suggestion from my experience here.  I would break apart your program into sections, make an initial attempt at a solution for one part, then post questions/errors/etc here asking for advice on that part. 
  
  For example, take your #1 item and try passing dummy data to the calendar view and see if you can get it to work.  If not, make a post asking about the calendar view control.  Once you solve the calendar view problem, move to the next step and if you run into problems, make a new post about that particular part.  You will get more responses on small questions than how to code an entire complex program.
  
  

  Here is a quick example of sending email with Outlook.

  Option Explicit
  
  Dim App As Object
  Dim Itm As Object
  
  Set App = CreateObject("Outlook.Application")
  Set Itm = App.CreateItem(0)
  With Itm
     .Subject = "Email Subject"
     .To = "[email protected]"
     .Body = "Some text"
     .Send
  End With
  
  
  
  
  
  
  
  
  
  
  
  

  And here is a tutorial on interfacing to Outlook Calendar that you may find useful in getting started.
  
  

  /Tril
  
  

  
  

  Report abuse
• • Reply

  14 years ago

  by akidi

  Man

  , Guatemala

  Joined 14 years ago

  Hi Trilarian ,

  Thanks very much for your assistance and quick response and suggestions. I really appreciate it. I will do as you suggested. the problem was that I have been trying so many ways but without success, trying to achieve all at the same time. I guess i have to use the divide and conquer approach as you pointed out. I will get back as soon as i run into any problems.Best regards

  Report abuse