Gain access to Email
 

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 didnt get any answers
Many thanks
John

Gain access to Email
 

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

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