Using T-sql stored procedures with Mail Merge

  • Thread starter Thread starter Sylvester Simmons via AccessMonster.com
  • Start date Start date
S

Sylvester Simmons via AccessMonster.com

Is there any way to use or refer to a sql stored procedure in a vb mail
merge program?
 
Not directly, You cannot use T-SQL from within VB. You can pass a
SQL-Statement (ANSI-92 compliant SQL) from VB, and you can run a Stored
Procedure using T-SQL and use ODBC to connect and merge with the Stored
Proc's output.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best solution to merge multiple Outlook contacts easily 2
Invalid Column Name Sql-Error :Executing a stored procedure 1
What are the steps to fix damaged MDF files in SQL Server? 0
From Access how to create stored procedure in SQL server 4
Using Stored Procedures With Access Data Project 2
How to call a stored procedure with paramters in SQL Server Express 2008, using code 3
How to execute SQL strored procedure from Access 6
Open a word mail-merge document from Excel VBA 1

Back
Top