[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Letters

Posted on 2009-02-23
2
Medium Priority
?
489 Views
Last Modified: 2012-05-06
I have been asked to create some letters in SQL for our customers.  We are migrating to a new front end customer management program.  When we send letters out to customers the code has to be written in SQL, then exported to a file to be sent to our mail house.  I have been working with SQL reporting for years.  I have not created form letters before.
I need help getting started.
0
Comment
Question by:gracie1972
2 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 2000 total points
ID: 23714240
This would ideally be configured using SQL Server Web Assistant which can produce HTML output at scheduled intervals..

Have a look at the following link -

http://msdn.microsoft.com/en-us/library/ms953440.aspx

0
 

Author Closing Comment

by:gracie1972
ID: 31550166
I will have to see if the mail house can work with HTML output, thank you for your suggestions I will comment back if it works.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Integration Management Part 2
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question