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
"Stu Lock" <s.****@cergis.com> wrote in message
news:Oy*************@tk2msftngp13.phx.gbl...
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