Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Extracting data from Outlook


  • Please log in to reply

#1
kefalo

kefalo

    New Member

  • Member
  • Pip
  • 2 posts
I need to extract some data from my inbox. In the body of emails that have a similar subject (only the receipt number is different) are the name and the email address of customers. The fields are always in the same place and the format of the email is completely standardized. I need to avoid going through the inbox and copy/pasting the needed data into Excel. Can this be done? Nenad
  • 0

Advertisements


#2
Crowbar

Crowbar

    Teacher

  • GeekU Moderator
  • 3,911 posts
I'm pretty sure it can be done, most likely thru VB code. Are you familiar with VB - Visual Basic?

I've been using Access to populate some Excel spreadsheets, different but similar, with some neat VB code.

VB is not really for the faint of heart, but it's not impossible to use.

check these links:
http://blogs.techrep...msoffice/?p=744
http://www.dicks-cli...lRetrieving.htm

If the code in those links doesnt scare you too much :D , then some creative google searching should get you closer to your goal. If I had to pull data from emails into spreadsheets, that's the route I would take.
  • 0

#3
kefalo

kefalo

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
found the tutorial for exactly what I need but I am not that tech savvy, will try anyway

here is the tutorial: http://blogs.techrep...msoffice/?p=744
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP