Check out Dick's site for a example
http://www.dicks-clicks.com/excel/ol...eving%20E-Mail
Or
http://www.dicks-clicks.com/excel/ol...%20Attachments
I don't know if this is working in Outlook 98.
But I am sure you can read this on the site
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Keith" wrote in message m...
Hello -
I am wondering if there is a way in VBA to open emails that are in
my Inbox. I have Excel 97 and I use Outlook 98. Eventually, I want to
open emails from a specific sender with a specific subject, open the
.xls attachment in each email, and get data from that attachment. Is
this possible?
Thanks,
Keith