[AccessD] Outlook MSG files

Mark A Matte markamatte at hotmail.com
Fri Aug 26 08:20:05 CDT 2011


Thanks for all of the responses.
 
No code necessary...I dropped all of the .msg files that where sent into an outlook folder...(import would not work???)... and then  used the export feature to generate an Excel file.
 
Thanks All,
 
Mark A. Matte
 
 

> From: stuart at lexacorp.com.pg
> To: accessd at databaseadvisors.com
> Date: Fri, 26 Aug 2011 19:44:35 +1000
> Subject: Re: [AccessD] Outlook MSG files
> 
> Forget it. Import them into an Outlook folder and manipulate them from there.
> 
> The problem is that MS in their wisdom decided to take a plain text transmission and save it 
> with a lot of binary information.
> 
> Take a look at one of those plain text message files in a Hex editor :-(
> 
> 
> -- 
> Stuart
> 
> On Thu, Aug 25, 2011 at 5:38 PM, Mark A Matte
> > <markamatte at hotmail.com>wrote:
> > 
> > >
> > > Hello All,
> > >
> > > I have a couple 100 .msg files.
> > >
> > > I need to open(in access?) them and extract the info. No
> > > attachments,
> > just
> > > text (all same format)
> > >
> > > Anyone have any VBA tricks/advice?
> > >
> > > Thanks,
> > >
> > > Mark A. Matte
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> > -- 
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> > 
> > 
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
 		 	   		  


More information about the AccessD mailing list