Import data from Outlook 2003 to Excel 2003

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.
 

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

Top