Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outlook Connectivity
Team --
I'm working on an app that will collect information in a users email inbox, sort it and pull specific field information from an HTML based form. Once it's got that information, it sorts through and matches information in the workbook and makes the appropriate calculations in different fields. (Think of a field reporting tool that collects monthly sales data from 300+ distributors and automates the data entry portion) I'm comfortable with sorting through the process once I get the data out of Outlook, but I'm struggling with where to start with the connection and controlling Outlook from Excel. Anyone have any advice on where to start or some references that might lead me to some good tools? Thanks mdb |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outlook Connectivity
Hi mdbuelow
Start here http://www.dicks-clicks.com/excel/olRetrieving.htm -- Regards Ron de Bruin http://www.rondebruin.nl "mdbuelow" wrote in message ... Team -- I'm working on an app that will collect information in a users email inbox, sort it and pull specific field information from an HTML based form. Once it's got that information, it sorts through and matches information in the workbook and makes the appropriate calculations in different fields. (Think of a field reporting tool that collects monthly sales data from 300+ distributors and automates the data entry portion) I'm comfortable with sorting through the process once I get the data out of Outlook, but I'm struggling with where to start with the connection and controlling Outlook from Excel. Anyone have any advice on where to start or some references that might lead me to some good tools? Thanks mdb |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outlook Connectivity
Perfect, thanks Ron!
"Ron de Bruin" wrote: Hi mdbuelow Start here http://www.dicks-clicks.com/excel/olRetrieving.htm -- Regards Ron de Bruin http://www.rondebruin.nl "mdbuelow" wrote in message ... Team -- I'm working on an app that will collect information in a users email inbox, sort it and pull specific field information from an HTML based form. Once it's got that information, it sorts through and matches information in the workbook and makes the appropriate calculations in different fields. (Think of a field reporting tool that collects monthly sales data from 300+ distributors and automates the data entry portion) I'm comfortable with sorting through the process once I get the data out of Outlook, but I'm struggling with where to start with the connection and controlling Outlook from Excel. Anyone have any advice on where to start or some references that might lead me to some good tools? Thanks mdb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ODBC connectivity logon's | Excel Discussion (Misc queries) | |||
Data connectivity across two seperate .xls files, interesting | Excel Worksheet Functions | |||
Outlook connectivity problem! | Excel Discussion (Misc queries) | |||
Excel 2002 Add-in: Open Database Connectivity available for Excel | Excel Discussion (Misc queries) | |||
Asking for the connectivity of excel | Excel Programming |