Visual Basic Run Time Error 5852
Pete, as you may recall when we were working on this code together originally, we were able to remove code referring to the database access because it was built in already I would love for this to work everytime. I've even copied over the normal.dot, thinking that may be part of the issue. just had a call from an old client who cannot merge a document from his database ... http://digitalfishbowl.net/visual-basic/visual-basic-run-time-error-525.html
Doug Robbins - Word MVP wrote in message oups.com... Already a member? The script executes correctly until this is performed (which is when I get the error message listed above): With oWord.ActiveDocument.MailMerge .Destination = wdSendToNewDocument .Execute End With Again, this works when executed Sign up now! https://social.msdn.microsoft.com/Forums/en-US/7b0f97de-3584-4e91-a1aa-482f149fbeb5/runtime-error-5852-requested-object-not-available?forum=vbgeneral
Your name or email address: Do you already have an account? Removing all markup from numeric value in a cell 6 27 56d Word 2013/2016 Saving as Temp File 9 27 44d Vb script to restart the services 13 58 21d Word Similar Threads run-time error "3211" Michelle Rainer, Jul 17, 2003, in forum: Microsoft Access Forms Replies: 0 Views: 264 Michelle Rainer Jul 17, 2003 'Run-time error 2501. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.
Join & Ask a Question Need Help in Real-Time? It is a lot smaller, and hopefully more maintainable It captures the main document into a variable, to avoid the ambiguity of the ActiveDocument Sub mailmergetemp2() Dim docMain As even so, you need declare the constant, wdsendtonewdocument or replace it with the zero value, Odoc.MailMerge.Destination = 0 or const wdsendtonewdocument = 0 as currently it is doing nothing i do Anyone have any idea what else it could be and how to resolve this?
How does a main mail merge document lose it's database? Error# 5852 Requested Object Is Not Available « Previous Thread | Next Thread » Thread Tools Display Modes #1 June 27th 06, 10:26 PM posted to microsoft.public.word.mailmerge.fields Close Box Join Tek-Tips Today! http://www.vbforums.com/showthread.php?612725-Urgent-quot-Requested-object-is-not-available-quot Craps out with Word XP and Word 2007.
What am I missing? https://bytes.com/topic/visual-basic/answers/648478-run-time-error-5852-word-mail-merge-macro Any other ideas of something I may be missing? Jenn Reply With Quote May 2nd, 2010,06:05 PM #10 JennEx View Profile View Forum Posts Thread Starter Member Join Date Apr 2010 Posts 51 Re: Urgent: "Requested object is not available." Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Ben Butler's Visual Basic for Applications Welcome to my VBA Notebook As I use Visual Basic for Applications, I will post lessons learns, cool links I have found and code snippets. http://digitalfishbowl.net/visual-basic/visual-basic-namespace.html Join UsClose 418,683 Members | 1,090 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members FAQ home > topics > visual basic 4 / A registration? Microsoft cannot guarantee that these problems can be solved.
Error on XP machine that has been corrected - http://support.microsoft.com/kb/264754/en-us code example currently - If AppWord.ActiveDocument.MailMerge.DataSource.DataFields("Name1").value <> txtName1 Then With Dialogs(wdDialogMailMergeFindRecord) .Find = txtName1 .Field = "Name1" .Execute This tool will scan and diagnose, then repairs, your PC with patent pending technology that fix your windows operating system registry structure. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. navigate here The only problem is that it works fine under one Windows profile, but when I log in as a different user (same rights), it fails with the above error message.
I suspect that the datasource is not available to that user because it is in the original users C:\Documents and Settings\[username]\My Documents\My Data Sources folder. -- Hope this helps. All of these locations are on a server which both profiles have access to. I recreated the word doc and everything works fine (fingers crossed).
Below is a little info, thanks in advance.
Join our community for more solutions or to ask questions. Haven't tried Word 2003. Set wrdApp = CreateObject("Word.Application") wrdApp.Documents.Open FileName:=strContractDir & "\" & strDoc, AddToRecentFiles:=False, Visible:=False wrdApp.Documents(strDoc).Activate With wrdApp.Documents(strDoc).MailMerge .DataSource.FirstRecord = 1 Line causes error (Error 5852: Requested object is not It look more like Word VBA. The only problem is that it works fine under one Windows profile, but when I log in as a different user (same rights), it fails with the above error message.
Having the problem right now. me thinks there is something amuk between the two computers I've been working on this code with. Prior to going over to Office 2003 we have not had any problems with this functionality. http://digitalfishbowl.net/visual-basic/visual-basic-2015-pdf.html The script executes correctly until this is performed (which is when I get the error message listed above): With oWord.ActiveDocument.MailMerge .Destination = wdSendToNewDocument .Execute End With Again, this works when executed
You'll be able to ask any tech support questions, or chat with the community and help others. So I am thinking that we need to find a way to code around this. Last edited by JennEx; Apr 27th, 2010 at 08:01 AM. This article contains information that shows you how to fix Microsoft Visual Basic Runtime Error 5852 both (manually) and (automatically) , In addition, this article will help you troubleshoot some common