Recent content by accessDatabase

  1. A

    Capturing Send Variables without using Application_ItemSend in ThisOutlookSession

    Great, thanks for that, that's got it working now. All the best!
  2. A

    Capturing Send Variables without using Application_ItemSend in ThisOutlookSession

    Hi Diane, yes I've got an IF block in there, unfortunately the Private Sub olSentItems_ItemAdd(ByVal Item As Object) isn't being fired after I've sent an email. Perhaps I've got it set up wrong?
  3. A

    Capturing Send Variables without using Application_ItemSend in ThisOutlookSession

    Hi, I've put this code into thisOutlookSession and assigned 'Say Yes' to a custom button on the ribbon. I click that button, then click the Send button, but it's not firing the code. Any suggestions? Option Explicit Dim SetFlag Private WithEvents olSentItems As Items Private Sub...
  4. A

    Capturing Send Variables without using Application_ItemSend in ThisOutlookSession

    Hi Diane, thanks for your reply. When I paste this code into a module I get a compile error on WithEvents saying Only Valid in Object Module. Which parts go in which type of module? Option Explicit Dim SetFlag Private WithEvents olSentItems As Items Private Sub Application_Startup() Dim...
  5. A

    Capturing Send Variables without using Application_ItemSend in ThisOutlookSession

    Hello, I want to place a custom button in the send window's ribbon which allows me to capture the sender, recipient, subject, body and date/time sent and pass these through to an Access database then send the email as normal. I have found out how to get these variables using the...
Top