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

No comments:

Post a Comment