Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
import mail messages in excel
Hi there,
I want to import mailmessages from Outlook (or *.txt files from a directory) into excel and make from every message a database record. Is this possible? Every message has the same size and lines, when I try tot do this every line goes on a new row therefore I should transpose it or somehow (but don't know how :-(. Thanx for every hint |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
import mail messages in excel
Arnie
You can access those messages using the code found here http://www.dicks-clicks.com/excel/olRetrieving.htm Then you just need to parse the Body property into its components. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Arnie" wrote in message .nl... Hi there, I want to import mailmessages from Outlook (or *.txt files from a directory) into excel and make from every message a database record. Is this possible? Every message has the same size and lines, when I try tot do this every line goes on a new row therefore I should transpose it or somehow (but don't know how :-(. Thanx for every hint |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
import mail messages in excel
Supadoopa!
Thanks. "Dick Kusleika" schreef in bericht ... Arnie You can access those messages using the code found here http://www.dicks-clicks.com/excel/olRetrieving.htm Then you just need to parse the Body property into its components. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Arnie" wrote in message .nl... Hi there, I want to import mailmessages from Outlook (or *.txt files from a directory) into excel and make from every message a database record. Is this possible? Every message has the same size and lines, when I try tot do this every line goes on a new row therefore I should transpose it or somehow (but don't know how :-(. Thanx for every hint |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
import mail messages in excel
Additional question:
How can I set the focus back on Excel? "Arnie" schreef in bericht .nl... Supadoopa! Thanks. "Dick Kusleika" schreef in bericht ... Arnie You can access those messages using the code found here http://www.dicks-clicks.com/excel/olRetrieving.htm Then you just need to parse the Body property into its components. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Arnie" wrote in message .nl... Hi there, I want to import mailmessages from Outlook (or *.txt files from a directory) into excel and make from every message a database record. Is this possible? Every message has the same size and lines, when I try tot do this every line goes on a new row therefore I should transpose it or somehow (but don't know how :-(. Thanx for every hint |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
import mail messages in excel
Arnie
I don't know what you're doing, but in general the focus should never leave Excel. You might post the code you are using. You also might look in help at AppActivate and see if that does what you want. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Arnie" wrote in message .nl... Additional question: How can I set the focus back on Excel? "Arnie" schreef in bericht .nl... Supadoopa! Thanks. "Dick Kusleika" schreef in bericht ... Arnie You can access those messages using the code found here http://www.dicks-clicks.com/excel/olRetrieving.htm Then you just need to parse the Body property into its components. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Arnie" wrote in message .nl... Hi there, I want to import mailmessages from Outlook (or *.txt files from a directory) into excel and make from every message a database record. Is this possible? Every message has the same size and lines, when I try tot do this every line goes on a new row therefore I should transpose it or somehow (but don't know how :-(. Thanx for every hint |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing saved e-mail messages | Setting up and Configuration of Excel | |||
Best way to import data from an e-mail to an excel sheet? | Excel Discussion (Misc queries) | |||
hyperink outlook mail messages to cells in excell | Excel Discussion (Misc queries) | |||
delete blocked senders messages on receipt why junk mail them? | Excel Discussion (Misc queries) | |||
Extracting Data from MS Outlook Mail Messages | Excel Programming |