 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / January 2005Why do I get 2 copies?
Hi- I have Word97. I am running a mail merge using VBA code. When the data are merged, I get 2 identical copies of my document. (Each is 18 pages long.) I only call the WordBasicMailmerge routine once. Where is the second copy coming from? What could be causing it to happen? Thanks in advance for looking at this. -Marty It would be helpful to actually see the code that is giving you problems. You may want to post it in the vba.beginners or the word97vba newsgroup.  SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > Hi- I have Word97. I am running a mail merge using VBA code. When the data > are merged, I get 2 identical copies of my document. (Each is 18 pages [quoted text clipped - 4 lines] > > -Marty Charles- That sounds like it would be helpful. But I do not see either of those groups. Where do I find them? Thanks, again, Marty > Hi- I have Word97. I am running a mail merge using VBA code. When the data > are merged, I get 2 identical copies of my document. (Each is 18 pages long.) [quoted text clipped - 3 lines] > > -Marty Post it here if you can't find them. SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > Charles- > [quoted text clipped - 14 lines] >> >> -Marty I'm posting the code here until I can navigate to the vba group. When the code below is called, I get 2 complete documents generated: WordBasic.MailMergeMainDocumentType 0 WordBasic.MailMergeOpenDataSource Name:="", ConfirmConversions:=0, ReadOnly:=0, LinkToSource:=0, AddToMru:=0, PasswordDoc:="", PasswordDot:="", Revert:=0, WritePasswordDoc:="", WritePasswordDot:="", Connection:="DSN=GAVURAH;UID=sa;PWD=;APP=Microsoft Query;WSID=SHIVAINDRA;LANGUAGE=us_english;DATABASE=lp_patents", SQLStatement:="execute splp_lppci_US " & Chr(34) & OrderLetterNumber & Chr(34), SQLStatement1:="" WordBasic.MailMerge CheckErrors:=1, Destination:=0, MergeRecords:=0, From:="", To:="", Suppression:=0, MailMerge:=1, MailSubject:="", MailAsAttachment:=0, MailAddress:="" Thanks, Marty > Post it here if you can't find them. > [quoted text clipped - 16 lines] > >> > >> -Marty I would suggest that you re-write the code using "pure" VBA rather than the VBA implemenation of the WordBasic commands. SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > I'm posting the code here until I can navigate to the vba group. > [quoted text clipped - 36 lines] >> >> >> >> -Marty |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.