[AccessD] Outlook MSG files

Brad Marks BradM at blackforestltd.com
Thu Aug 25 20:40:20 CDT 2011


Mark,

There are probably many ways to do this.

I often use an Open Source (free) tool called AutoHotKey for "Utility"
type jobs.

I like AutoHotKey for such tasks because it is powerful, free, stable,
easy to use, and has very good online documentation.

Below is AutoHotkey code what will combine all of the data from all
".txt" files found in a specified folder.

If I needed to work with the data from a large number of files, 
I would first combine the data into one file and then pull this single
file into Access.

If you have any questions, feel free to ask.

Brad
   

;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~
; Merge all of the data from all .txt files (in Input folder) into a
single combined output file


Input_Folder = C:\Input_Folder

Output_File = C:\Output_File.txt


; Delete Output File
FileDelete %Output_File%  

; Loop thru Input Folder, obtaining file names, read and store data
found in each file, append data to Output File

Loop, %Input_Folder%\*.txt  
{
 FileRead, Data_In_Input_File, %A_LoopFileFullPath%    ; Obtain all the
data from a file and store in a variable
 FileAppend, %Data_In_Input_File% `r`n, %Output_File%  ; Write the data
stored in the variable to the output file
                                                       ; NOTE:    `r =
Carriage Return      `n = Line Feed    
} 


; Display Output File
Run, %Output_File%

Msgbox File Merge Complete
;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jack
drawbridge
Sent: Thursday, August 25, 2011 7:35 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Outlook MSG files

Hi Mark,
You got any sample data?

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.





More information about the AccessD mailing list