Letter Merge

3 posts, 0 answers
  1. Sean Gough
    Sean Gough avatar
    4 posts
    Member since:
    Feb 2006

    Posted 14 Feb 2008 Link to this post

    I want to write a small batch utility (C# or VB.NET) that will query a database, find X number of records that match my criteria and then merge them into letters (based on various templates) that can be printed and mailed.  Ideally I can save as a single print a control sheet too (i.e. one line per page for spot check information) but individual PDFs would be acceptable too.

    Is it possible to use Telerik Reporting as a mail merge tool like this? 

    Also, does TR support bar codes? (for imaging)

  2. Svetoslav
    Svetoslav avatar
    649 posts

    Posted 15 Feb 2008 Link to this post

    Hi Sean Gough,

    I do believe that Telerik Reporting can do the job for you. There are significant differences between MS Word and Telerik Reporting (for example in MS Word you can format a part of the text while in Telerik Reporting you style the report items and if this is a TextBox item the style is applied to the whole text it displays) that you should have in mind while creating your reports (the templates for the letters).

    To get a better overview of what Telerik Reporting can do we encourage you to play with the accompanying samples (in both C# and VB.NET) and give it a try.

    Regarding the bar codes - we still lack this functionality out of the box; anyway it is in our TODO list and I hope we will have the time and resource to work on it soon. However, some of our existing customers have successfully displayed bar codes on their reports by using a special bar code font and the TextBox report item.

    Sincerely yours,
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. Martin Beeby
    Martin Beeby avatar
    60 posts
    Member since:
    Nov 2006

    Posted 15 Feb 2008 Link to this post

    Just so you’re not hunting for too long. If you want to concatenate text and fields in a text box then you need to do the following in the value field:

    = "Dear " + Fields.Fname + " " + Fields.Lname + " welcome to the club"

    Ensuring you use + rather than &. Since & is not recognised.

    Regarding barcodes. You could probably use a third party tool and create a bracode image (there are open source ones out their) then create a function that reurns an image and just call this image on the databind event of a picture box.

Back to Top