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

No comments:

Post a Comment