Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HELP WITH AUTO EXPORT FROM OUTLOOK TO EXCEL
Hello!
Does anyone know of a way to automatically export email from outlook based upon certain criteria in the email and have it sent to excel - some sort of query? Thanks! |
#2
|
|||
|
|||
Hi Mel,
AFAIK, this is not easily done, but you can import Exchange emails into Access, and pull it from there. Yuo can link the tables in Access, and write a query that filters the results and dunps into a table, which you can then pick up with Excel - either manually, or by linking Excel to Access via ODBC. Hope this helps Sunil Jayakumar "Mel" wrote in message ... Hello! Does anyone know of a way to automatically export email from outlook based upon certain criteria in the email and have it sent to excel - some sort of query? Thanks! www.ayyoo.com/credit-cards.html |
#3
|
|||
|
|||
Hello Sunil,
Thank you...that will get me on the right track. Regards, Mel "Sunil Jayakumar" wrote: Hi Mel, AFAIK, this is not easily done, but you can import Exchange emails into Access, and pull it from there. Yuo can link the tables in Access, and write a query that filters the results and dunps into a table, which you can then pick up with Excel - either manually, or by linking Excel to Access via ODBC. Hope this helps Sunil Jayakumar "Mel" wrote in message ... Hello! Does anyone know of a way to automatically export email from outlook based upon certain criteria in the email and have it sent to excel - some sort of query? Thanks! www.ayyoo.com/credit-cards.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I export data from Excel to Outlook | Excel Discussion (Misc queries) | |||
How do I export email addresses from excel to outlook? | Excel Discussion (Misc queries) | |||
I want to do mass mailing in outlook, from an excel file that has. | Excel Discussion (Misc queries) | |||
Excel client list in to Outlook | Excel Discussion (Misc queries) | |||
Excel Copy/Paste into Outlook | Excel Discussion (Misc queries) |