Search results

Huh, I'm surprised no one here knows. I didn't think this would be so esoteric....

First, I can get close by opening the .msg and inserting a 'response', but I cannot get ".reply" to work - I think my syntax / usage is just not correct. As a result, I need to manually insert my signature, while I believe using "reply" would automatically insert it, etc. etc. Second, I don't...

I'm sorry, but...bump

I have code that allows me to drag and drop an email to an access field, which then stores that email on the local / network folder. Another field with that email's file path is also displayed. My big question is: knowing the email's file path, how can I have the system open those...

I reviewed the code and I have a much better handle on it now. I've done incorporation and it works wonderfully. I'm not going to venture in to weighting frequency of terms (ex., if it matches > 3 times, then...) since I don't think this is a good measure of predictability. But thank you so...

Thank you very much for the further explanation. I'm stepping out for the weekend, but will continue to try to get this right again on Monday. In the meantime, I wanted to thank you again for taking the time to help with a solution and to explain it to me.

Thanks a ton, I really appreciate the time you spent on providing this information! I follow the logic but I'm still a little fuzzy on how to integrate with the something like msg.Subject. I would have thought I should define SearchText or replace it with msg.Subject? I can't see where that...

Thanks a ton for the response! I see what you're saying. The text likely will only contain one key word; in case there are two, it should just be first match. If there's a match, then it'd be great to end the check. Once we finish going through the list of keywords to check, if there's no match...

I'm sorry, but...bump

The below snippet is part of a bigger piece of code. Essentially, I'm trying to transform the code to make it more versatile. To this end, rather than having values hard-coded in the VBA, I'd like for the VBA to read those values from a table. I'd like the code to loop through the table's...

My solution: using Form_Delete Private Sub Form_Delete(Cancel As Integer) Dim KillFile As String If Not IsNull(Me!MailLocation) Then KillFile = Me!MailLocation Kill KillFile ElseIf IsNull(Me!MailLocation) Then End If End Sub I could have probably inserted something in there to verify, like to...

I have 10 posts now, and so can post links. For completeness, I wanted to provide example code that I saw, at the below site, and which used Form_AfterDelConfirm: http://science.nature.nps.gov/im/units/ARCN/data_management/code/277.htm Private Sub Form_AfterDelConfirm(Status As Integer)...

I hate to answer two of my questions, but I wanted to share my solution in case someone else finds it helpful. Now the last step, finding out how to insert text from a field into the .msg... 'This command below will search the email body for the following words and if found, insert them...

I have one other element that I'm trying to implement in my Access DB - that is, to search a saved email (.msg) subject & body for certain text, and then follow this with conditions - if A, then update me.Title with 1, if, B, update me.Title with 2, if C, update me.Title with 3, etc. etc. I'm...

Thanks a ton for the reply. I got this idea in part when I saw a piece of code online that used that AfterDelConfirm. Most people here will just right click on the row and delete it that way, but I think it'd be a good idea if I could tell them to first remove the attachment by clicking on...

I was hoping someone could help me with the correct syntax that would delete a file when the record is deleted. The file's path is listed in a record field, MailLocation. Every time I try this code, I receive an error! I've tried the below, and number of iterations, including calling the...

Re: When drag-drop Outlook email into Access, extract "Subject", edit msg "Body"? I hate to answer my own question - especially when that answer's a workaround - but I wanted to post what I did since this might help others. Basically, I renamed the static file using a scrubbed me.Title - which...

Re: When drag-drop Outlook email into Access, extract "Subject", edit msg "Body"? I apologize, but I have to...bump....

Re: When drag-drop Outlook email into Access, extract "Subject", edit msg "Body"? I updated some of the code above, so that the particular saved .msg is read and certain information is extracted to populate the relevant Access fields (subject, from). However, this only achieves half the effect...

When drag-drop Outlook email into Access, extract "Subject", edit msg "Body"? Hi, The below code allows a user to drag an email from Outlook to an Access field; the code will then save the email as a msg in a defined folder, using a filename that is derived from two of the Access fields. The...