Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2004
    Thanked 0 Times in 0 Posts

    Excel Extraction (2000)

    I want to try and take something to the next level (well at least it will be for me!) and I just need a few pointers and weather it can or can't be done!

    I'll soon be receiving a form I've designed in Outlook via email. It has lots of different texts boxes etc in it.

    Now what I would like to be able to do is write a macro in excel which will go to my in box and look through it for this email form I'll be receiving, grab all the data from the text boxes and return it to an excl spreadsheet.

    Is this possible?

    Thanks for any help.....!

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Weert, Limburg, Netherlands
    Thanked 0 Times in 0 Posts

    Re: Excel Extraction (2000)

    Sure this is possible. It does require some serious VBA knowledge though, both the object model of Outlook and the OM of Excel has to be used.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts