Search results

  1. I

    Pass ID Of Row In Click Event

    Yes, that is it perfectly!! Thank you for the assistance.
  2. I

    Pass ID Of Row In Click Event

    @arnelgp in another thread of mine gave me a function that would open a form filtered to show only the specific ID information for the row I clicked on my form. My database became corrupted and I had to re-create it and now it is not working. In the double click event of the field on my form I...
  3. I

    Double Click Record In Form

    I had to set pop up property to Yes When the form loads the text is highlighted. Is there a way that the text is not all highlighted when the form loads?
  4. I

    Double Click Record In Form

    And lastly how can I set this form to display over the current visible form? Not to display maximized?
  5. I

    Double Click Record In Form

    how do I set the text box on the form that loads showing comments to be non editable? I do not see it in the properties
  6. I

    Double Click Record In Form

    I have a form set to continuous view. I was wondering if there is a way that a user can double click a specific row in the form and on the double click launch a separate form that shows all of the user_notes for the clicked record?
  7. I

    VBA To Reply All Email

    Hi - post 28 - is functioning for me, I just have one mishap I am having with he code. When I open the email, I want to ADD new text to the email chain. When I use the code in this post it ONLY adds the 'new' text that I code in. With olReply .BodyFormat = olFormatHTML .HTMLBody =...
  8. I

    VBA To Reply All Email

    The message above the last one printed is a meeting invite for Skype for Business. Is there a way to search only emails?
  9. I

    VBA To Reply All Email

    If I change as suggested I now get a error in the line Next olMail The error is Type Mismatch
  10. I

    VBA To Reply All Email

    Hi - I tried testing your code (no alterations) but I am getting an error of Run-time error ‘438’: Object doesn’t support this property or method And this is the trouble line If olMail.To = searchEmail Then
  11. I

    VBA To Reply All Email

    I am needing to reply all and keep the previous correspondence showing in the email thread. Are you suggesting that every time an email is sent to manually add date/time email body, email subject etc to a local table?
  12. I

    VBA To Reply All Email

    Saving the data in access would only give me the email address and the date of last email sent...I'd still need to access the Outlook object to "Reply All" to the last email tho...
  13. I

    VBA To Reply All Email

    The site swapped out the quotes. I have stepped through the code and the issue I found is the .To is giving (forgive my ignorance and lack of terminology here) the name and not email. For example, if I sent an email to Tom.jones@test123.com what the code shows is ‘Tom Jones’ not the actual...
  14. I

    VBA To Reply All Email

    Knowing when it was sent isn’t as big of a deal. What my end game here is finding the last sent email and “reply all” and add text to that message from access vba. Now manually inputting this into an access table could help narrow down the specific date to scan sent mail for.
  15. I

    VBA To Reply All Email

    I feel like I’m close, but I keep getting not found even tho I sent an email to this address today. What’s up? Dim olFldr As Outlook.Folder Dim olNs As Outlook.NameSpace Set olNs = olApp.GetBamespace(“MAPI”) Set olFldr = olNs.Folders(validemailtosearch).Folders(“Sent Items”) For Each...
  16. I

    VBA To Reply All Email

    Only requirement is to the specified email address. If The email address was emailed 20 times and three times yesterday, then grab the latest time stamp so it’s the most recent email to the specified email address Does that clarify?
  17. I

    VBA To Reply All Email

    I’ll look into the outlook model and see if cvs can do it. I was wanting this to take place from a button press event on an access form, but I’ll take almost any option!
  18. I

    VBA To Reply All Email

    I was assuming as much, but def not the answer I was hoping for. I’m trying to automate a process that someone wastes hours on daily.
  19. I

    VBA To Reply All Email

    I have seen lots of threads on how to create an email with access vba, but I want to pass an email address to a 'search' function and scan my "Sent" mail in outlook for the most recent email to the email address. Once found, I want to "Reply All" the email (so that it sends to the original...
  20. I

    VBA To Create Email

    That resolved. Thank you kindly.
Top Bottom