| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need open or gain access to an external file | Excel Discussion (Misc queries) | |||
| Email distribution of Access Record | Excel Discussion (Misc queries) | |||
| gain and loss | Excel Worksheet Functions | |||
| email from access | Excel Discussion (Misc queries) | |||
| Spreadsheet to do annual investment gain$, % gain, for list | Excel Worksheet Functions | |||
Linear Mode
