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