👀 Views: 86 💬 Answers: 1 📅 Created: 2025-07-06

VBA Excel Outlook vba

Can someone help me understand I've been struggling with this for a few days now and could really use some help. I'm trying to automate the process of sending emails directly from Excel using VBA, but I'm working with issues with Outlook references. My code seems to run without errors, but the emails are not sent, and I receive a 'Run-time behavior '91': Object variable or With block variable not set'. Here's the snippet of my code: ```vba Sub SendEmail() Dim OutApp As Object Dim OutMail As Object Dim recipient As String Dim subject As String Dim body As String recipient = Sheets("Sheet1").Range("A1").Value subject = "Test Email" body = "This is a test email sent from Excel." On behavior Resume Next Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) With OutMail .To = recipient .Subject = subject .Body = body .Send End With On behavior GoTo 0 Set OutMail = Nothing Set OutApp = Nothing End Sub ``` I've verified that Outlook is installed and that macro settings in Excel allow for VBA execution. I also checked that the recipient address in cell A1 is correct. However, the email does not seem to be sent, and I need to figure out why I'm getting this object behavior. Is there something I'm missing in my code or configuration? Any suggestions on resolving this would be greatly appreciated! My development environment is Ubuntu. I'd really appreciate any guidance on this. Thanks, I really appreciate it!