Consulting

Results 1 to 3 of 3

Thread: My new Outlook stops here

  1. #1
    VBAX Newbie
    Joined
    Oct 2023
    Posts
    1
    Location

    My new Outlook stops here

    Hi,

    Could please help me with this problem. I have new outlook and my VBA stops at this moment.

    Sub Mail()
    ActiveSheet.Range("A1:D44").Select
    ActiveWorkbook.EnvelopeVisible = True - STOPS HERE! 
       With ActiveSheet.MailEnvelope
    Last edited by Aussiebear; 10-30-2023 at 06:09 AM. Reason: Added code tags to supplied code

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,059
    Location
    Welcome to VBAX Dasiek91. Hopefully someone will be along shortly to assist you here.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    VBAX Expert Logit's Avatar
    Joined
    Sep 2016
    Posts
    613
    Location
    Using just the code you've provided in your post ... it functions as expected here.

    Option Explicit
    
    Sub Mail()
    ActiveSheet.Range("A1:D44").Select
    ActiveWorkbook.EnvelopeVisible = True '- STOPS HERE!
       With ActiveSheet.MailEnvelope
       End With
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •