|
|
Hi all,
I have a question about reading .dbx files (OE mailbox files) with Excel
macros.
I recieve mails generated by a webform and i want to write the data in excel
sheet. Is there a way to acces .dbx files from Excel using macros? Or should
I copy/paste the data manualy?
All help is appcreciated.
Jan
PS: No, i do not have acces to the webserver, so i can not write the data to
a database of any kind.
Post a reply to this message
|
|
|
|
And lo on Mon, 24 Mar 2008 14:00:44 -0000, JWV
<j.w.a.vaandrager|at|planet.nl> did spake, saying:
> Hi all,
>
> I have a question about reading .dbx files (OE mailbox files) with Excel
> macros.
>
> I recieve mails generated by a webform and i want to write the data in
> excel
> sheet. Is there a way to acces .dbx files from Excel using macros?
Not unless you buy/write your own libraries. Unlike Outlook proper,
Outlook Express doesn't use VBA so you've no internal 'handles' to
manipulate its file store. You could use another language if it had
built-in dbx support, but of the top of my head I can't think of any;
others here may be of help there
> Or should
> I copy/paste the data manualy?
May be your only option, remember VBA does have the ability to 'grab' the
contents of the clipboard so you could copy the data then run a macro in
Excel to parse and store it.
--
Phil Cook
--
I once tried to be apathetic, but I just couldn't be bothered
http://flipc.blogspot.com
Post a reply to this message
|
|