Jim Dettman
jimdettman at verizon.net
Fri Aug 26 07:43:05 CDT 2011
And don't forget, you can create a linked table to an Outlook folder; no need for code even to read the contents of every message. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Friday, August 26, 2011 05:45 AM To: Access Developers discussion and problem solving 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