VBA Outlook Screen Updating

[jalrs]

Hello forum experts,

As the subject suggests I'm having trouble with outlook screen updating. I would like to turn it off, meaning that every time I run the macro, the outlook doesn't pop up a new window. Instead, it should just keep running on the taskbar. I've tried with Application.ScreenUpdating method, but this fails to work.

Any help is greatly appreciated.

Sub mailIsencao()

Dim OutApp As Object
Dim OutMail As Object
Dim ws1 As Worksheet, ws2 As Worksheet

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
Set ws1 = ThisWorkbook.Worksheets("Readme")
Set ws2 = ThisWorkbook.Worksheets("MACRO 4")

ws2.Activate

On Error Resume Next

Application.ScreenUpdating = False

    With OutMail
        .To = Cells(2, 2).Value
        .CC = Cells(2, 3).Value
        .Subject = Cells(2, 4).Value
        .Body = Cells(2, 7).Value
        .Display
        .Attachments.Add "C:\Users\joafrodrigue\Desktop\share\finaldocname\ST_Isenção.xlsx"
        
    End With
    On Error GoTo 0

Set OutMail = Nothing

ws1.Activate

Application.ScreenUpdating = True

End Sub

Thanks

 

[Micron]

That error pretty much always means your code project is missing a reference. Check if you've referenced Outlook xx Object Library.
When you Dim oApp As Object you are using late binding - vba figures out what object to create when you set.
When you Dim oApp As Outlook.Application that is early binding and you definitely need the object library for that. I'd say you cannot use Inspector without the library reference because Inspector is specific to Outlook.

Also, I pasted my own variable from code (EmailItem variable). You have to use your own variable(s): OutMail

 

[jalrs]

That error pretty much always means your code project is missing a reference. Check if you've referenced Outlook xx Object Library.
When you Dim oApp As Object you are using late binding - vba figures out what object to create when you set.
When you Dim oApp As Outlook.Application that is early binding and you definitely need the object library for that. I'd say you cannot use Inspector without the library reference because Inspector is specific to Outlook.

Also, I pasted my own variable from code (EmailItem variable). You have to use your own variable(s): OutMail

Thanks for the reply Micron.

However as I'm new to VBA, I don't understand the concepts you are talking about. Apologies.
If you could provide an explanation on how to perform the things you have listed I'd more than happy to look through them. Otherwise, if you lack the time, or the will, since I'm new and this might take a while, I will suggest my boss that we use .Send method, even if mistakes could follow within the e-mail.

Thank you once again Micron!

 

[Micron]

Whenever somebody uses a term or phrase you don't understand, try Googling it. More than likely the term or phrase will be close enough to get you the info you need, especially when it involves technical terms or jargon. See if this helps
"ms access how to set references vba"

Set references to type libraries

Office VBA reference topic

docs.microsoft.com

I know that what I posted works so maybe don't throw in the towel yet as sending mail as/with mistakes is easy to prevent (to a point, of course).

 

[jalrs]

Whenever somebody uses a term or phrase you don't understand, try Googling it. More than likely the term or phrase will be close enough to get you the info you need, especially when it involves technical terms or jargon. See if this helps
"ms access how to set references vba"

Set references to type libraries

Office VBA reference topic

docs.microsoft.com

I know that what I posted works so maybe don't throw in the towel yet as sending mail as/with mistakes is easy to prevent (to a point, of course).

I will have a look and comeback to you.

Thanks for googling it for me. Since I wasn't familiar with the terms, I thought the task was huge, that's why I said what I said

Thanks again!

 

[jalrs]

@Micron

Since I will reference to all e-mail details based on cell values, parametrized values, I'll change to .Send method.

Thanks for your time!

 

[Micron]

You're welcome. Good luck with your project!

 

[krzys1991]

not sure if this has been resolved, but I thought this might help:

Outlook.Application.ActiveInspector.WindowState = olMinimized

this allows you to minimalise the active Outlook window so perhaps incorporating it in your code could help you to get rid of the visual pollution...