Integrating Database Data into a label template based on user inpu

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wryen Meek - 28 Apr 2006 18:25 GMT

Software: Microsoft Office Professional 2003

Situation:

I would like to create a very easy to use Word Template that generates a
label based on data I have in an Access Database. I would like to be able to
open the document and be prompted to input a list of datasets to generate
labels for. I would also like to be able to recyle old label sheets, so I
need to specify which label sections in the template to skip. I know how to
acomplish this in Access - But I really dont want to recreate a bunch a Avery
Label Templates in the form of Acess Reports. Also my co-workers dont have a
clue how to use Access nor can I count on those that come after me to know
Access - therefore it would be nice to do this in Word, a program that they
know how to use.

Can anyone point me in the right direction or offer some suggestions?

Thanks

Reply to this Message

Doug Robbins - Word MVP - 28 Apr 2006 19:13 GMT

The label wizard in Access is probably easier to use than mailmerging to
labels in Word.

The only way to skip "used" labels is to add the necessary number of blank
rows at the beginning of the data source, or put the label sheet in the
other way around (assuming the top and bottom margins are the same) and then
merge the appropriate number of records to use up the labels, then do a
second merge starting at the next record number.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Software: Microsoft Office Professional 2003
>
[quoted text clipped - 19 lines]
>
> Thanks

Reply to this Message