MailMerge DataSource problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marty (anonymous_at_discussions.microsoft.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 06:03:33 -0700

Hi-

I'm running Word97. I have a DOT template which runs a
macro. In the macro, I have an ADO connection to get my
data. I also have WordBasic.MailMergeOpenDataSource
statement which keeps bombing out with error 1535, saying
that there were no records to be returned. This is
because the stored procedure is probably not returning
anything. (I want to eliminate the stored procedure, not
fix it.)

But I already have all the info that I need from the ADO
connection. And, I get this into the document using
ActiveDocument.Variables.Add commands.

How do I execute the Mail Merge without the stored
procedure?

Thanks for all the help.

Relevant Pages

  • Re: Error 2950
    ... What is the error message? ... It is intriguing to note that you seem to be using the macro to close a form, and then open the same form again. ... Steve Schapel, Microsoft Access MVP ... the macro does run the stored procedure ...
    (microsoft.public.access.macros)
  • Error 2950
    ... So I built a macro to launch a pre-built package. ... an append qry. ... the macro does run the stored procedure ...
    (microsoft.public.access.macros)
  • RE: Cannot obtain recordset from stored procedure that contains Ex
    ... I am guessing the extra messages issued by the Exec ... calls were either confusing the ADO connection or actually returning multiple ... >> call a stored procedure that stuffs records into another table using a SQL ... >> temp table in the stored procedure. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Locking Problem
    ... I am using CA with ADO connection + SQL2000. ... > I have a VFP8 application that calls a stored procedure that runs the ... > The query ofther users are running is a stored procedure call that runs ...
    (microsoft.public.fox.vfp.queries-sql)
  • run time error 2147217900
    ... I have a macro that runs a sql stored procedure and brings ... back a record set. ... It doesn't matter which stored procedure I'm ...
    (microsoft.public.excel.programming)