Import data from Outlook 2003 to Excel 2003

  • Thread starter Thread starter jazzbah
  • Start date Start date
J

jazzbah

Hi I'm a newbie to groups but would like to get some code to import
data from the InBox of Outlook into an Excel spreadsheet. I'm
imagining I would have a button in Excel to click to import certain
fields from Outlook. In particular, I would like Excel to go to the
current item in the Inbox (i.e. the selected item) and import details
from that email such as "Subject", "From", "Recd Dt" etc. I would
then go to the next email, which may not be the one underneath the
current one, i.e. I select a mail item from somewhere else in the
InBox, click the button, Excel retrieves the data from Outlook and
puts it into the ActiveSheet wherever. I then pick another email and
import it and so it goes. Any help with coding this would be
welcome. Thanks in advance. Dave.
 
Thanks Ron, I'll check out the links you have included and try those out in
my code.
 

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

Back
Top