Solved

Creating mailing labels within VB - any label controls available?

Posted on 2003-11-11
1
406 Views
Last Modified: 2008-02-01
I have an access database, and want to use it for (among other things) printing mailing labels. I'd rather do this via a mailing label control - one which would support the hundreds of label types available. I'm trying to avoid using MS Word since it would (I'm assuming) require the user to first develop a document with the type of mailing label he's using.

I'd rather do it all via VB, and not require the user to know anything about using MS Word - it's possible the end user wouldn't even have MS Word on his system.  I'd rather that the users only responsibility would be to identify the fields, identify how it's sorted, confirm the type of label he's using, and then insert the labels into the printer.  I want to do the rest - making it easy for the end user.

Does anyone know of a good way to do this?  I'm willing to use MS Word - but preferably as the last resort. Any help is appreciated.

Thanks
0
Comment
Question by:rcmb
1 Comment
 
LVL 28

Accepted Solution

by:
AzraSound earned 250 total points
ID: 9725551
Have you looked at Crystal Reports?  It has many different label formats (e.g., Avery labels) already predefined in its report template library.  Couple that with its easy drag-and-drop report expert for creating the labels tied to your database and it may be an optimal solution for you.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA open file from excel cell 4 44
Paint/Redraw window while dragging 16 83
Updates not working for MS Windows 7 12 183
Exit a vb6 apps when a calling it apps closes 15 53
Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question