473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Using VB.NET to do label printing

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
Nov 20 '05 #1
1 7203
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

Nov 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: madeo | last post by:
hi, i'm looking for some script which would export address labels from a mysql db to pdf ... There's an exapmle, but i'm not able to convert it for using with mysql ... can anybody help? THX...
1
by: achintya.jha | last post by:
Hi, I am currently working hard to print Word labels from ASP.NET I have multiple records which I need to print on to a word label print functionality. I know that Word Label printing prints...
13
by: Susan Beebe | last post by:
I have downloaded the code described in Microsoft article Q154078. I am trying to send raw ZPL (zebra barcode printer) code from Microsoft access. It works just fine if I hard code the actual...
0
by: Jordi | last post by:
I'm making a feature-file to train a Neural Network, but now that I've added a new feature, the output becomes corrupted. The output is as follows: 3000 25 1_002858 5 0 0 0 0 2 2 0 0 0 0 2 2 0 0...
1
by: Anish G | last post by:
Hi, I am trying to print multiple label images in case of ups multi label implementaion. The response i get in XML schema and from that i parsedout the label images and stored in an array and from...
1
by: Simon Verona | last post by:
I have the requirement for address label printing within my software. I have a name and address list in a ado.net in-memory dataset - I'd like a pre-built software library which will display a...
1
by: steve | last post by:
Hi All Has anybody had experience with printing text and barcodes to Zebra label printers in VB.net 2005 Regards Steve
12
by: brwalias | last post by:
Hi, using .net 2 sql server 2005 Here is my situation: I'm passing a variable in the url from a selection on Page A and need to display the results on the Results page be based on that...
1
by: =?Utf-8?B?R2VvcmcgRmxlaXNjaGVy?= | last post by:
Hello, I've got a problem which I can not locate. I will try to describe it and would be glad, if someone had an idea how to identify the cause of the problem. Situation: My application...
1
by: vfpgood | last post by:
Hello,guy! My work is to design labels. Can anyone introduce a simple, easy and professional system for bar code label design . Set design drawings, generate bar code generation and batch...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.