Home > Runtime Error > Runtime Error 5852 Word Merge

Runtime Error 5852 Word Merge

I get the same run-time error 5852 when we first ran on a new XP server, this was corrected via the following link in MS knowledgebase. http://support.microsoft.com/kb/264754 Here's the Google search I picked this up in: http://www.google.com/search?hl=en&r...o+&btnG=Search Please let us know if more help is needed... All rights reserved. I understand that, in a recent update, this behavior was changed to display the message as soon as a document is detected as a mail merge document. his comment is here

i have a similar problem with the same error number. Next by Date: macro to delete parts of the document Previous by thread: Re: Event bubbling in forms? The default value is no (No, don't attach the datasource), and when using automation, you are not given the opportunity to respond "yes". Requested object is not available' message when I use Access 2003 to send data to a word (2003) mailmerge document.

Jenn Reply With Quote May 2nd, 2010,05:23 PM #8 westconn1 View Profile View Forum Posts PowerPoster Join Date Dec 2004 Posts 22,070 Re: Urgent: "Requested object is not available." does the Get 1:1 Help Now Advertise Here Enjoyed your answer? This other error we are not able to correct in the same manner.Both of the issues stem from the FindRecord,FirstRecord,etc calls to the access database. Thanks to mdmackillop & austenr for all your help.

HesabımAramaHaritalarYouTubePlayHaberlerGmailDriveTakvimGoogle+ÇeviriFotoğraflarDaha fazlasıDokümanlarBloggerKişilerHangoutsGoogle'a ait daha da fazla uygulamaOturum açınGizli alanlarGrupları veya mesajları ara Re: Word Mail Merge Run time 5852 Error From: Curt Date: Wed, 3 Sep 2008 15:11:01 -0700 Running 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 You may have to register before you can post: click the register link above to proceed. Here is a sample of the code I used in the past. ************************************************** ***************** Private Sub Command0_Click() Dim w As Word.Application Dim m As MailMerge Dim mm As MailMergeDataSource Dim d

MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines Website Testing Ask a Question Copyright 2004-2016 OfficeFrustration. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free!

Not saying this is your whole problem but it might get you a little closer. Related Sites Visual Studio Visual Studio Integrate VSIP Program Microsoft .NET Microsoft Azure Connect Forums Blog Facebook LinkedIn Stack Overflow Twitter Visual Studio Events YouTube Developer Resources Code samples Documentation Downloads May 20 '07 #2 reply P: 1 rmwatts Hi Brodie, did you find a resolution to this problem? I will assume then that it also lost it's SQL query?

Go to Solution 3 2 2 Participants GrahamSkan(3 comments) LVL 76 MS Word65 VB Script16 cslt(2 comments) 5 Comments LVL 76 Overall: Level 76 MS Word 65 VB Script 16 Depending on what that is, that line of code could be fairly straight-forward or a pain to figure out. just had a call from an old client who cannot merge a document from his database ... I appreciate any thoughts.

Friday, August 25, 2006 1:06 PM Reply | Quote 0 Sign in to vote dear gavin, thank you for your post. http://cdhca.org/runtime-error/runtime-error-word-2002.php So I am thinking that we need to find a way to code around this. It's likely you've already seen this, brodie! Here's what worked for me....

me thinks there is something amuk between the two computers I've been working on this code with. Can anyone offer a solution how to resolve this error? Join & Ask a Question Need Help in Real-Time? weblink no value, no zero ...

My code: Code: Sub merge() Set ObjWord = CreateObject("Word.Application") Set Odoc = ObjWord.documents.Open(Range("D43").Value) ObjWord.Visible = True Odoc.Application.Visible = True Odoc.mailmerge.Destination = wdsendtonewdocument Odoc.mailmerge.Execute Set Odoc2 = Odoc.Application.documents("Catalog1") Odoc.Close False mypath = Results 1 to 11 of 11 Thread: Urgent: "Requested object is not available." Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch The document, on it's own, works fantastic.

Any Ideas Thanks "Cindy M." wrote: Hi Diane, In Word 2003 (and I thought 2007) opening a Word document using automation unlinked the data source, so no message would appear.

Prev by Date: Re: Event bubbling in forms? Does this happen every time? The mail merge portion goes as follows:With docWord.MailMerge.Destination = wdSendToNewDocument.SuppressBlankLines = TrueWith .DataSource.FirstRecord = wdDefaultFirstRecord.LastRecord = wdDefaultLastRecordEnd With.Execute Pause:=FalseEnd WithIt has worked without a hitch for the last six months. Similar topics word Mail merge Driving word mail merge Using MonthName Function In MS Word Mail Merge From Access Word mail merge from Access with parent child records MS Access and

This is the most critical part of my Excel based application ... Now, vba is saying that the ".Destination = wdSendToNewDocument" line generates a "runtime error 5852" message stating that the requested object is not available.So my question is in two parts:1- How Post your question and get tips & solutions from a community of 419,092 IT Pros & Developers. http://cdhca.org/runtime-error/runtime-error-word-2000.php Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis.

I'm using Office 2003 I'm trying to automate a mailmerge to Word from Excel. I have a problem with a mail merge procedure I used to use with Access '97. Prior to going over to Office 2003 we have not had any problems with this functionality. I am trying to merge individual records into seperate mail merge word docs.

It would be great if you could provide some insight. Oct 31 '07 #3 reply 100+ P: 113 alpnz Ditto for me ... So far I've tried the suggestions in these two MS articles: http://support.microsoft.com/kb/913804/ http://support.microsoft.com/kb/825765/ So far neither of these have worked. Question has a verified solution.

Have you tried redefining the datasource; go through the mailmerge wizard again. 0 LVL 76 Overall: Level 76 MS Word 65 VB Script 16 Message Active today Assisted Solution by:GrahamSkan Works like a charm with Office/Word 2000. Can't I sign the macro (with a security certificate)? All rights reserved.

Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required No errors. RE: Runtime error 5852 during Access-Word mail merge Creosote65 (TechnicalUser) (OP) 19 Apr 05 11:58 Hi JoyInOK,The register edit that you referenced is exactly what is needed to resolve the error. just blank.

All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. I have some code in the Word DocumentOpen event, which looks like this: With ActiveDocument.MailMerge .Destination = wdSendToNewDocument .Execute However, the code fails at the: .Destination = wdSendToNewDocument line with the We recently converted to Office XP (2002) and I now have an issue I am unfamilliar with and have been unable to resolve. Covered by US Patent.

msgbox wdsendtonewdocument should show 0 Hi Pete! Both computers are running Excel 2003 SP3. 2) All files, referenced in this project are on a thumb drive, and both computer A and B work off this thumb drive as Shouldn't that be recomended in the knowledge base? So far I've tried the suggestions in these two MS articles: http://support.microsoft.com/kb/913804/ http://support.microsoft.com/kb/825765/ So far neither of these have worked.