ActiveX runtime error 429 when creating Lotus Notes object from VBA

Problem:

vba code creates Lotus Notes object, initiates the session and sends email. However the Notes registry needs updated and the users dont have access to C: drive to run the reg file.

solution:

create a batch file which will run the reg fix:

#######################################
Windows Registry Editor Version 5.00

Regedit.exe /s C:\Lotus\Notes\NOTESW32.REG
Regedit.exe /s C:\Lotus\Notes6\NOTESW32.REG
#######################################

save as a .bat file and run!