|
Posted to microsoft.public.excel.programming
|
|
|
Gain access to Email
Thank you Tom
"Tom Ogilvy" wrote:
You can use automation. Download the automation help file for information
and sample code:
http://support.microsoft.com/?id=167223
OFF97: Microsoft Office 97 Automation Help File Available (Q167223)
http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available (Q260410)
--
Regards,
Tom Ogilvy
"JohnUK" wrote in message
...
Hi All,
Is it possible to get into the email application via VBA in excel?
Reason:
I need a code that can pick up a certain subject within email inbox,
(Outlook 2003) open the email and then open the attachment (always the
same
name) I can do the code from there to transport the data from the file
into a
database, and then I need it to close the email and attachment and start
on
the next one and so on.
I did post something similar yesterday, but I didn't get any answers
Many thanks
John
|