SQL Letters

Posted on 2009-02-23
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.
Question by:gracie1972
    LVL 25

    Accepted Solution

    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 -


    Author Closing Comment

    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.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    How to increase the row limit in Jasper Server.
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now