Showing posts with label merge. Show all posts
Showing posts with label merge. 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!

Monday, March 19, 2012

How to use PublisherEncryptedPassword?

I'm doing merge replication over the net using the ActiveX replication
library.
The SQLMergeClass has a property called PublisherEncryptedPassword
(string). There is absolutely no documentation for this anywhere on the
web (that I can find, anyhow).
How do I use this? Do I have to provide an encrypted password? If so,
what type of encryption do I use?
I'm assuming that this exists to enable me to send an encrypted
password instead of plain text.
Thanks for any info -
JJ
have you tried
declare @.retcode int
declare @.distributor_enc_password nvarchar(524)
set @.distributor_enc_password='stuff'
EXEC @.retcode = master.dbo.xp_repl_encrypt @.distributor_enc_password OUTPUT
print @.distributor_enc_password
print @.retcode
This property is hidden and undocumented. It could be used in WSM.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JJ" <joe.jabour@.gmail.com> wrote in message
news:1123031272.303748.285010@.g44g2000cwa.googlegr oups.com...
> I'm doing merge replication over the net using the ActiveX replication
> library.
> The SQLMergeClass has a property called PublisherEncryptedPassword
> (string). There is absolutely no documentation for this anywhere on the
> web (that I can find, anyhow).
> How do I use this? Do I have to provide an encrypted password? If so,
> what type of encryption do I use?
> I'm assuming that this exists to enable me to send an encrypted
> password instead of plain text.
> Thanks for any info -
> JJ
>
|||Thanks - that shows me how to encrypt my password, but I am not able to
authenticate with it for some reason.
Does PublisherEncryptedPassword replace PublisherPassword?
I am not using WSM.
JJ