Recent content by Anastasios Diamantopoulos

  1. A

    Focus on the userform

    Hi, I actually found the trick to work and it looks preety simple. Just had to initialise the form with a focus to one of its buttons and did the trick: Private Sub UserForm_Initialize() Me.CommandButton1.SetFocus End Sub
  2. A

    Focus on the userform

    Any other ideas on how can I make my form Modal?
  3. A

    Focus on the userform

    Excuse me, but what makes you believe that I'm not showing the code I'm really using...? Outlook 2007: ThisOutlookSession: Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim strSubject As String Dim myForm As New EmailPrioForm strSubject = Item.Subject...
  4. A

    Focus on the userform

    Hmmm, this did not work either.
  5. A

    Focus on the userform

    A I mentioned, I replaced EmailPrioForm.Show vbModal with EmailPrioForm.Show 1 and it does not work. They have exactly the same behavior.
  6. A

    Focus on the userform

    The code is as follows: Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim strSubject As String strSubject = Item.Subject If Len(Trim(strSubject)) = 0 Then prompt$ = "Subject is Empty. Are you sure you want to send the Mail?" If...
  7. A

    Focus on the userform

    I did it and it does not work. I call the ExampleForm.Show vbModal from the ItemSend, when I click on the email's send button the form appears but while the form is opened I can click (outside the form) on the email and make changes. This is what I try to avoid. I do not want the user to be able...
  8. A

    Focus on the userform

    This is the statement I call the form: ExampleForm.Show vbModal. How this will be when I want to call it with 1?
  9. A

    Focus on the userform

    I have created a VBA Macro which uses the ItemSend Even to modify the Subject of an email. Form within ItemSend I call a userform (ExampleForm.Show vbModal)with 3 buttons. The userform works perfectly well and when the user clicks a button the Subject is replaced and the mail is fired. However...
  10. A

    Application_ItemSend not accessed when sending email outside outlook (i.e. word or send to mail from

    Hmmm, I see it is far more complicated than I initial thought. Thank you very much for your prompt response!!! Anastasios PS. If you come across with such sample of code, I'll welcome it!!! Thank you again!
  11. A

    Application_ItemSend not accessed when sending email outside outlook (i.e. word or send to mail from

    Hi again, thanks for your prompt support. The outlook version I use is 2007 and the aforementioned scenario took place with outlook opened. There is no possibility to run VBA on the other program. Is there any way to capture these events from within itemSend (from ThisOutlookSession)? Thanks...
  12. A

    Application_ItemSend not accessed when sending email outside outlook (i.e. word or send to mail from

    I have a working piece of code in the ThisOutlookSession that traps when the user is sending an email, except if the mail is sent from Word or Excel by using the Save&Send (as attachment or pdf) option. I can't find any hint anywhere of how to make the code work also when doing it this way. The...
Top