Showing posts with label msword. Show all posts
Showing posts with label msword. Show all posts

Wednesday, March 21, 2012

How to use SQL stored proc as datasource for MS Word mail merge?

Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?
Yes but I believe it depends on what version of Word. You
can use MS Query, select whatever for the tables and then
edit the SQL text in MS Query. You can use something like:
{call YourStoredProcedure}
There is also an OpenDatasource method of the MailMerge
object.
-Sue
On Fri, 6 Aug 2004 14:40:15 -0500, "Fred Zolar"
<fzolar@.yahoo.com> wrote:

>Is it possible to use a SQL Server stored procedure as a datasource for MS
>Word mail merge? If yes then how?
>

How to use SQL stored proc as datasource for MS Word mail merge?

Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?
Fred Zolar wrote:
> *Is it possible to use a SQL Server stored procedure as a datasource
> for MS
> Word mail merge? If yes then how? *
Have you figured this out? If so, I would be interested as I am
trying to do the same thing.
carolyn01
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message340375.html
|||Fred Zolar wrote:
> *Is it possible to use a SQL Server stored procedure as a datasource
> for MS
> Word mail merge? If yes then how? *
I found a way to get this to work. I created a view in SQL Server
placing the SQL in the view instead of the stored procedure. Then I
pointed the Word Merge document to the view. It works. Hope that
helps!
carolyn01
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message340375.html

How to use SQL stored proc as datasource for MS Word mail merge?

Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?
quote:
Originally posted by Fred Zolar
Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?


Have you figured this out? If so, I would be interested as I am trying to
do the same thing.|||
quote:
Originally posted by Fred Zolar
Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?


I found a way to get this to work. I created a view in SQL Server placing
the SQL in the view instead of the stored procedure. Then I pointed the Wor
d Merge document to the view. It works. Hope that helps!