PDA

View Full Version : My new Outlook stops here



Dasiek91
10-30-2023, 03:18 AM
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

Aussiebear
10-30-2023, 06:10 AM
Welcome to VBAX Dasiek91. Hopefully someone will be along shortly to assist you here.

Logit
10-30-2023, 10:51 AM
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