Printable View
I've generated a query and results are put in a listbox with the companies listed. All I want to do is to allow my software user to generate a customized letter in which user can assign any field anywhere and then press a button and a customized should be printed with info of all the clients listed. I know the crystal report method in which i made a document with assigning fields and a letter was generated to all but i want my user to do from my software itself.
If your user is using Microsoft Word and knows how to
use the Mail Merge feature, you may consider the way
I am doing for the same thing.
You may export the list of the companies into a
pre-defined ms-word document(data source) through automation. This file should contain a table with the first row as header, typically, the field names. Then populate all the companies information into the table, one compnay
one record. As long as your user know the file name
and the field name, they can create their own letter
template file (the main doc). Then do Mail Merge with
your data file (catalogs are created as the end product).
Or you may also create the template for the main document,
so that your user can modified it to whatever they like.
This way you can really make it, after the initial modification, the things left for your user, is only
a single click.
If the list is very long, Word may be too slow to be the data source, you can use Excel as the data source,
and then merge it to Word.
Good luck,
Tony
Quote:
Originally posted by rajatojha
I've generated a query and results are put in a listbox with the companies listed. All I want to do is to allow my software user to generate a customized letter in which user can assign any field anywhere and then press a button and a customized should be printed with info of all the clients listed. I know the crystal report method in which i made a document with assigning fields and a letter was generated to all but i want my user to do from my software itself.