VBA - compile error. cannot find project or library

[ssh99]

I have a VBA to automate generation of emails on Outlook with attachments. The query used to work OK but I now get the following error: Compile error. Cannot find project or library.
Not sure how to fix this so any help would be great. The VBA code is:

Sub Display_Emails()

Dim OutApp As Object
Dim OutMail As Object
Dim OutAccount As Outlook.Account
Dim NewMail As Outlook.MailItem

For i = 2 To Sheet1.Cells(Rows.Count, 2).End(xlUp).Row
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
Set OutAccount = OutApp.Session.Accounts.Item(1)
Set NewMail = OutApp.CreateItemFromTemplate("C:\Users\SITA\Desktop\test template.oft")

On Error Resume Next
With NewMail
.To = Cells(i, 2).Value
.Attachments.Add Cells(i, 3).Value
.Display
End With
On Error GoTo 0

Set OutMail = Nothing

Excel file:

 

[SeniorNewbie]

Hi 99,
may be it helps to set Microsoft Office 16.0 Object Library or Microsoft Outlook 16.0 Object Library in the references or the VBE?
Best wishes
Senior Newbie

 

[ssh99]

Hi 99,
may be it helps to set Microsoft Office 16.0 Object Library or Microsoft Outlook 16.0 Object Library in the references or the VBE?
Best wishes
Senior Newbie

Thanks for your reply. Microsoft Office 16.0 is already selected from what I can see...

 

[SeniorNewbie]

Open the VBE (aka Visual Basic Editor) by Alt+F11. Go to menu bar > Extras > References and select the two proposed referenceses. Consider: This reference is only available for your active workbook.

 

[SeniorNewbie]

but ...? I mentioned a 2nd reference ...

 

[ssh99]

but ...? I mentioned a 2nd reference ...

I've added both now but the same error message still comes up.

 

[SeniorNewbie]

okay - then

1. deactivate the lines on error ...
2. debug the code line by line with F8
3. and btw: there's no chance to help with only a part of the code. So helpers can only guess, bu not find the problem