-
May 25th, 2010, 11:43 AM
#1
-2147319779 (8002801d) Automation Error - Library Not Registered
I created an input request form database using Access 2003 which automatically creates an email using VBA to create the email. In the VBA environment, I selected the reference to the Microsoft Outlook 11.0 Object Library. This program works fine on all computers using Windows XP but we recently purchased a laptop with Windows 7 running Office 2003 and on that computer the runtime error -2147319779 (8002901d) Automation error - library not registered occurs. I believe the problem is a DLL file that is missing but have no idea which DLL file. Does anyone have any suggestions on how to fix this problem? I have included the code and where the error occurs for reference:
Private Sub cmdSubmitRequest()
Dim olApp As Outlook.Application
Dim olNS As Outlook.NameSpace
Dim olfolder As Outlook.MAPIFolder
Dim olMailItem As Outlook.MailItem
Dim varBodyText As Variant
Dim strName As String
Dim strDepartment As String
Dim strChargeNumber As String
Dim strRequiredDate As String
Dim strRequestDate As String
Dim strAddtionalInfo As String
Dim strWorkLocation As String
Dim strProductType As String
strName = "Last Name: "
strDepartment = "Department: "
strChargeNumber = "Charge Number: "
strRequiredDate = "Date Wanted: "
strRequestDate = "Date Written: "
strWorkLocation = "Location: "
strProductType = "Product Type: "
strAdditionalInfo = "Description of Work: "
Set olApp = CreateObject("Outlook.Application") Runtime Error Occurs At This Line of Code
Set olNS = olApp.GetNamespace("MAPI")
Set olfolder = olNS.GetDefaultFolder(olFolderInbox)
Set olMailItem = olfolder.Items.Add("IPM.Note")
This is only partial code. I did not want to bore you with details.
I appreciate any help you can give me. We will be in a transition period for some time running both Windows XP and Windows 7 so this will be an ongoing problem. Thank you for your help.
-
May 25th, 2010, 11:11 PM
#2
Re: -2147319779 (8002801d) Automation Error - Library Not Registered
Let me be cap'n obvious here, but have you checked to make sure that the outlook application was installed? If it is installed, has it been run the first time? Set up correctly? Send/recive emails as if user was operating?
Good Luck
-
May 25th, 2010, 11:35 PM
#3
Re: -2147319779 (8002801d) Automation Error - Library Not Registered
I started to give the same response earlier but .....
Always use [code][/code] tags when posting code.
-
May 26th, 2010, 09:16 AM
#4
Re: -2147319779 (8002801d) Automation Error - Library Not Registered
The computer is setup with Office 2003 professional and Windows 7 professional. All Outlook functions work properly. I am able to send and receive email manually just not programatically. My suspician is that the Microsoft Outlook 11.0 Object Library or one its components is not registered properly and therefore can not be found. I need help determining the names of the DLL files so I can use regsvr32.exe to register the libraries properly. Thank you for any help you can give me.
-
May 26th, 2010, 12:41 PM
#5
Re: -2147319779 (8002801d) Automation Error - Library Not Registered
Turn off Antivirus and Firewall, and temporarily turn of UAC, and it'll probably work.
With the combination of those three items, plus Windows 7, I'l guess that it's not likely to happen
-
October 30th, 2013, 05:56 AM
#6
Re: -2147319779 (8002801d) Automation Error - Library Not Registered
This worked for me! life saver! i have spend days trying to get my macro to work. thank you
-
October 30th, 2013, 09:57 AM
#7
Re: -2147319779 (8002801d) Automation Error - Library Not Registered
I am glad that you have found a problem to your solution. But, this is a 3 year old thread..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|