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?
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

No comments:

Post a Comment