Using VB.NET to do label printing

  • Thread starter Thread starter Stu Lock
  • Start date Start date
S

Stu Lock

Hi,

We have a SQL Server database with a database (~5000 user adresses) hosted
off site. At the clinets I need to be able to pull various groups out of the
db and print their details on to labels, letters & envelopes.

What is the best way to do this - bearing in mind the operator for this has
very little technical ability outside of email!

Is it possible to trigger a Word mailmerge using a specific templte from a
VB.Net app?

Sorry to be a bit vague - just not sure where to start.

THanks in advance,

Stu
 
Hi Stu,

It's really very easy. I don't know how much you know about t-sql, but you
simply have to run a query in a stored procedure and use the sp as the
source in a crystal reports report, which has to be developed for the
appropriate label type.

All of this should be part of a vb .net app that simply has the user select
the names of the groups to be included - the rest should be automatic, one
click of a button to run a crystal reports viewer control with the report
inside it.

HTH,

Bernie Yaeger
 
Back
Top