1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Link outlook to excel

Discussion in 'Software' started by Rob1234, Oct 26, 2007.

  1. Rob1234

    Rob1234 Megabyte Poster


    I am using outlook 2003 and excel 2003. I want to create a new task sheet and when people enter information in to the task sheet it is saved to an excel document but I do not know how to do this. Also I am using Exchange 2003.

    Certifications: A few.
  2. Ossian

    Ossian Bit Poster

    You will need to learn VBA and script it.

    The code would execute when someone adds a task item and the pseudocode would be something like this:

    Open Excel Object
    Open spreadsheet file
    Read item from task form
    Write item to cell
    Until no more items
    Save spreadsheet
    Close connection to Excel
    Close (and save) task form

    Google gives several examples to create a task from Excel, so it should be possible to reverse engineer the code e.g. http://en.allexperts.com/q/Excel-1059/sending-emails-tasks-Excel.htm

    Good Luck!
    Certifications: MCT, MCSE/A, MCDBA, MCDST, MCITP, Sec+
    WIP: Not sure....
  3. Mr.Cheeks

    Mr.Cheeks 1st ever Gold Member! Gold Member

    so different people are saving info on to the same xls sheet?
    can you not place the xls sheet on a share instead? of does this have to involve Outlook?
  4. wagnerk
    Highly Decorated Member Award

    wagnerk aka kitkatninja Moderator

    I was wondering why you needed it in .xls format?

    However if you are using Exchange with Outlook, you can create a new Public Folder that contains task items.

    To do this:
    Open Outlook -> Select Folder List -> Right CLick "All Public Folders" -> Create New Folder
    Give it a name and make sure that Folder Contains: Task Items, Click OK

    You may be able to do something with that. I offer that as an alternative cause if you use a .xls file on a shared area only one person can access it at a time and may cause problems.

    Good luck finding exactly what you need :)

    Certifications: CITP, PGCert, BSc, HNC, LCGI, PTLLS, MCT, MCITP, MCTS, MCSE, MCSA:M, MCSA, MCDST, MCP, MTA, MCAS, MOS (Master), A+, N+, S+, ACA, VCA, etc... & 2nd Degree Black Belt
    WIP: PGDip
  5. Rob1234

    Rob1234 Megabyte Poster

    I am going to do that but it is going to be used for people to book IT equipment out and I thought that they could use a task item to do that then the information they entered in to the task item could be saved to an Excel spreadsheet. Also I want to make it so that equipment can not be double booked. The fact that only one person can access the .xls file should not be a problem as we are a small IT team and only one person will probably be in charge of it.
    Certifications: A few.

Share This Page