Search results

With some help from Ace, we've come up with this so far: Private Sub FLDR_Click() Dim rs As DAO.Recordset Dim strPath As String strPath = Application.CodeProject.Path Dim olApp As Outlook.Application Set olApp = New Outlook.Application Dim olNS As...

Hello, In my quest to build a email message parsing tool, I can manually VBA code the folder location I wish to parse. But I'd rather provide a button on the form to which would result in a folder menu for the user to select where the parsing is to occur. This prevents a novice user from...

Ok, how about just grabbing the ReceivedTime of the Outlook mail item? That would work good enough I suppose. How do I do that? I've tried strDTG = strFileToParse.ReceivedTime and it doesn't work.

Update: Nothing resolved yet.

Kewl, will try this out and see how it works. Thanks!!

I was able to tweak this for a date, as opposed to a time. But it only updates if I put my cursor on that row again after putting data in A1. How can I make it automatically enter the date in B1 once hit the enter key down to A2? Here's the code I have thusfar: Private Sub...

Great info, thanks but when I use that formula, I get circular reference errors.

Any ideas on how to grab/parse that Date Time Group? I figure it may have something to do with specifying a specific amount grouping of alpha and numeric characters. I'm just unfamiliar with how to do that. It will always be ######Z LLL ## # = Number L = Letter Z = ZULU time, will always be...

A sample message looks like this: I have other Public Subs that take care of the Outlook stuff, like what folder to look in, etc... I have a separate module that does the line delimiting for the slashes. The below code does the actual line parsing: Public Sub ParseMSG(strFileToParse As...

I built an email parser that finds text based on message formatting. For example, the messages I parse have slashes in them as follows: SUBJ/MESSAGE SUBJECT/SENDER/MONTH// I simply parse the SUBJ line and end it with the // delimiter. Works GREAT! How to do code it to find text that isn't...