Home > Word Error > Word Error 5535

Word Error 5535

Follow-Ups: Re: runtime error 5535 From: cw References: runtime error 5535 From: cw Prev by Date: Create New Recipient List: Form vs. Dhana Mailmerge 1 January 5th 06 11:54 AM Visual basic runtime error 5216, there is a printer error [emailprotected] Microsoft Word Help 1 December 1st 04 12:22 PM All times are Last Modified On: March 19, 2016 +1 800-328-1000 [email protected] Systems & Network Management Business Intelligence Forms & Document Management Security & Compliance Copyright © 2016 HelpSystems HomeForumsWikiLinks HelpGuidelinesActive TopicsSearch Program ending." Set oApp = Nothing Set wrdMerge = Nothing Set wrdDoc = Nothing Set wrdApp = Nothing Unload Me End Sub Is This A Good Question/Topic? 0 Back to top check over here

To start viewing messages, select the forum that you want to visit from the selection below. Already a member? Any thoughts? Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Pauline" <> wrote in message news:... > Here is the code > > ' BFE 4/25/07 XXXXXX.

Password Site Map Home Register Authors List Today's Posts Search Web Partners Search Forums Show Threads Show Posts Advanced Search Go to Page... I'm using a Word template (.dot) for the form and a comma delimited file for the datasource. Join UsClose Log in or Sign up Microsoft Office Forums Forums > Archive > Newsgroup Archive > Word Newsgroups > Word VBA > Merge Error 5535 Discussion in 'Word VBA' started

  1. Glowacki, Feb 9, 2006, in forum: Word VBA Replies: 1 Views: 102 Peter Jamieson Feb 9, 2006 Mail Merge - Code to complete merge Craig Ferrier, Apr 29, 2006, in forum:
  2. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.
  3. It takes just 2 minutes to sign up (and it's free!).
  4. Change the macro to work in the current directory, rather than ' hardcoded to C:\Datatel.
  5. Still have questions?
  6. Can anyone > > help > > me? > > Thanks > > Renita > > Pauline, Jul 21, 2009 #3 Doug Robbins - Word MVP Guest What happens if
  7. shoelessjakeView Member Profile Jan 16 2004, 11:55 AM Post#6Posts: 42Joined: 20-August 03From: Dallas, TXMCP - tried your example and it opens the Word document but doesn't merge anything.
  8. You may have to register before you can post: click the register link above to proceed.
  9. Code follows: Option Explicit Dim WithEvents oApp As Word.Application Private Sub Form_Load() 'Start Word.
  10. If there is more than 1 data record, I get the the following error: 'Run-time error "5535"; Word could not finish merging these documents or inserting this database'.

Peter Jamieson "cw" wrote in message ... Public Sub MAIN() Dim objDatatelDot As Word.Document Dim objDoc As Word.Document Dim strCurPath As String ' Save object pointer to this document, so we can close it later Set objDatatelDot = Set wrdApp = CreateObject("Word.Application") wrdApp.Visible = False ' now create a new document based on the template Set wrdDoc = wrdApp.Documents.Add("C:\MMS\PURCHASE ORDER TEST.dot") With wrdDoc.MailMerge .MainDocumentType = wdFormLetters .OpenDataSource _ Name:="C:\temp\B9724.txt" Also update from the old Word95 basic code. ' This macro is linked to the Alt-M key.

Hi I am getting this error code '5535' while running a vb macro to do a mail merge in word 2007, I don't get it when I run the same macro The error is on the execute command. It will open DATATEL.DOC, which > was > just downloaded > ' to the client PC, update the merge data source to DATATEL.TXT which was > also just downloaded, > ' http://www.tek-tips.com/viewthread.cfm?qid=1616132 If I debug I get Visual Basic and the following is highlighted "objDoc.MailMerge.Execute".

If I choose the end option it goes to the >> > merged >> > document and all of the merged documents aren't there. >> > I have not idea what Member Login Remember Me Forgot your password? The new document created by the merge will still be open. ' These Files are deleted by Colleague as soon as the user indicates the merge is complete, ' but save Does the sSQL statement need to go before the ActiveDocument.MailMerge.DataSource.QueryString = sSQL statement and after the objWord.ActiveDocument.MailMerge.Destination = wdSendToNewDocument statement?Thank you in advance!

Not quite sure what this is all about, maybe you could explain?objWord.ActiveDocument.MailMerge.ExecuteI am with you, I think we are on the right track, I just can't figure out why it won't https://support.lexisnexis.com/system/selfservice.controller?CONFIGURATION=1057&PARTITION_ID=1&TIMEZONE_OFFSET=&CMD=VIEW_ARTICLE&ARTICLE_ID=57352&cust_prev_cmd=GET_NEXT_PAGE_RESULTS&cust_PrevNextFlag=true&cust_dfaqtopicId=-1&am If there is more than 1 data record, I get the the following error: 'Run-time error "5535"; Word could not finish merging these documents or inserting this database'. It will open DATATEL.DOC, which was just downloaded ' to the client PC, update the merge data source to DATATEL.TXT which was also just downloaded, ' and then run the merge. If I debug I get Visual Basic and the following is highlighted > > "objDoc.MailMerge.Execute".

I don't quite understand the code you have supplied.sSQL = "select * from tblMyTable where id = " & me.id1.) When it says "select * from tblMyTable should I be replacing check my blog Hi I am getting this error code '5535' while running a vb macro to do a mail merge in word 2007, I don't get it when I run the same macro The error is on the execute command. RE: Word/Excel Mail Merge Error osera (TechnicalUser) (OP) 13 Aug 10 15:28 Brilliant!When she asked me to have it sent to that printer, I assumed she was already connected.I set her

Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. RE: Word/Excel Mail Merge Error SkipVought (Programmer) 13 Aug 10 15:08 Please post your macro.Usually will better better results for VBA in forum707: VBA Visual Basic for Applications (Microsoft). Your name or email address: Do you already have an account? http://techkumar.com/word-error/word-error-5151.html If I choose the end option it goes to the > > merged > > document and all of the merged documents aren't there. > > I have not idea what

Skip,Just traded in my old subtlety...for a NUANCE! Skip,Just traded in my old subtlety...for a NUANCE! DATATEL.TXT has been downloaded ' to the same directory as this document. ' (Why not just DATATEL.TXT for both setup and actual merge?

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!

However, when I clicked "Debug", the statement below was highlighted in yellow. Set wrdApp = CreateObject("Word.Application") wrdApp.Visible = False ' now create a new document based on the template Set wrdDoc = wrdApp.Documents.Add("C:\MMS\PURCHASE ORDER TEST.dot") With wrdDoc.MailMerge .MainDocumentType = wdFormLetters .OpenDataSource _ Name:="C:\temp\B9724.txt" Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Pauline" <> wrote in message news:... > When creating a mail merge I get this message "Error 5535 Could not finish > Set objDoc = Documents.Open(strCurPath & "DATATEL.DOC") ' DATATEL.DOC was setup with merge data source HEADER.DOC, which contained only the field names. ' Now switch it to DATATEL.TXT, which will have the

Should that be what I enter in place of "id"?3.) Where in the code should I be placing the two sets of code you supplied above? Grid Next by Date: Re: Mail Merge .bmp from access? Skip,Just traded in my old subtlety...for a NUANCE! have a peek at these guys And, where would I insert it in my code above?Thanks, magconpresView Member Profile Jan 16 2004, 01:24 AM Post#4Posts: 166Joined: 21-December 03From: Portland, OR, USAJake --I'm not too familiar with Mail

Now replaced with > equivalent > VBA. > 'WordBasic.FileList 1 > 'WordBasic.FileOpen Name:="C:\DATATEL\DATATEL.DOC" > 'WordBasic.MailMergeOpenDataSource Name:="C:\DATATEL\DATATEL.TXT", > ConfirmConversions:=0, ReadOnly:=0, LinkToSource:=1, AddToMru:=0, > PasswordDoc:="", PasswordDot:="", Revert:=0, WritePasswordDoc:="", > WritePasswordDot:="", Connection:="", SQLStatement:="", SQLStatement1:="" Also update from the old Word95 basic code. > > ' This macro is linked to the Alt-M key.