View Single Post
  #5   Report Post  
Marty
 
Posts: n/a
Default

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


"Doug Robbins" wrote:

Post it here if you can't find them.

--
Please 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
"Marty" wrote in message
...
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

"Marty" wrote:

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