Determining Type of Label Used
by RGlhbmU » Tue, 18 Dec 2007 15:05:01 GMT
I'm using Word 2007. I have a file created by someone else that contains
mailing info formatted as labels. The problem is, I don't know what type of
labels to use! I've tried selecting the Mailings tab and clicking the Labels
button, then the Options button in the dialog box, but it is showing me a
standard Avery label that definitely doesn't correspond to what's in the
file. I believe that older versions of Word would show the label type
currently in use, but Office 2007 doesn't seem to do this. Does anyone have
any idea how to tell which label product number was used? I can't ask the
person who created the file. Thanks!
Re: Determining Type of Label Used
by Suzanne S. Barnhill » Tue, 18 Dec 2007 15:21:47 GMT
No, no version of Word will show you what type of label has been used, which
is why I usually try to remember to put the stock number in the Comments
field of the document Properties for label documents. About all you can do
is scroll through the label types to find one that has the same size or
number of labels as your document; it might be easier to do this in an
office supply catalog or at the Avery Web site than in the Labels dialog,
however.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Re: Determining Type of Label Used
by Graham Mayor » Tue, 18 Dec 2007 15:35:56 GMT
If you cannot figure it out by looking and measuring then extract the data
from the labels http://www.**--****.com/
and merge to a new label format that you do know.
http://www.**--****.com/
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://www.**--****.com/
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Re: Determining Type of Label Used
by RGlhbmU » Wed, 19 Dec 2007 02:19:01 GMT
Thank you Suzanne and Graham! I appreciate your help. I like the idea of
including the label type in the properties area, that's a great suggestion!
And, I appreciate the conversion method too -- if I can't figure out the
label type, at least I can resolve it another way.
Re: Determining Type of Label Used
by Dan Freeman » Thu, 20 Dec 2007 08:02:43 GMT
By the way, Graham, I've been meaning to thank you.
Thanks to your mailmerge pages, my Christmas cards went out on time this
year. (That's quite a first! <g>)
THANKS!
Dan
Re: Determining Type of Label Used
by Suzanne S. Barnhill » Thu, 20 Dec 2007 08:13:18 GMT
FWIW, I usually find it more efficient to create a mail merge for envelopes
and address them directly. I don't have an envelope feeder, so doing
hundreds would be a pain, but you still save the time of sticking labels on
the envelopes, and it also looks classier if you have colored envelopes and
don't use clear labels. You can also use larger type than you might on a
label (and include your return address as well).
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Re: Determining Type of Label Used
by Graham Mayor » Thu, 20 Dec 2007 16:17:14 GMT
I too merge directly to envelopes, but the linked pages are more general
than their filenames would suggest.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://www.**--****.com/
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Re: Determining Type of Label Used
by Graham Mayor » Thu, 20 Dec 2007 16:17:25 GMT
You are welcome :)
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://www.**--****.com/
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Re: Determining Type of Label Used
by Suzanne S. Barnhill » Thu, 20 Dec 2007 23:33:28 GMT
Ah, good, then. Judging by the number of typed letters we get in
hand-addressed envelopes (from law firms, for example), it seems that
printing envelopes, even singly, is an art many have not mastered. <g>
And those who know how to address envelopes evidently find that easier than
trying to print a single label (understandable) since many law firms send
large manila envelopes with an addressed #10 envelope taped on as the label.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Re: Determining Type of Label Used
by Dan Freeman » Fri, 21 Dec 2007 02:40:12 GMT
That's actually what I did. <g>
Dan
Re: Determining Type of Label Used
by Suzanne S. Barnhill » Fri, 21 Dec 2007 08:48:49 GMT
Great! Looks like we're all on the same page!
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Similar Threads:
1.determine label sheet used in mail merge
I need to know how to determine what Avery label sheet I used in a mail merge
in Word 2003 using an Excel spreadsheet for data. I am on XP. Anybody have a
clue?
Thanks,
Matt
2.I need to determine what avery label sheet I used in my merge
I can't find where to look to determine the Avery label sheet number I used
in a label mail merge. Anyone know?
Thanks
3.using a word table to type labels
How do I use a word able to create labels for mailing?
4.Determine type of OLE Control Object
I'm trying to determine how I can identify the type (textbox, label,
checkbox, listbox, combobox, ...) of an OLE Control Object that is on a
slide, programatically.
I want to be able to click on a shape in design view, then run a macro that
will tell me the type of a OLE Control object I have selected. Then, if it
is one that has a Text property, I want to display that. If it has a
caption property, I want to display that. If it has a list of items
(listbox or combo box), I would like to display the text associated with
each of the items.
I've got some rudimentary code that handles the ones with captions and
textboxes, but have not figured out how to iterate through the items in the
list of a combo or listbox. I know it has to be something like:
oShp.OLEFormat.Object.????????
5.HOWTO: Determine Application Type
I tried to find this out today, but couldn't find any answered posts (it's
been asked numerous times!
In the OnConnection method:
if( application is Interop.Excel.Application )
{
MessageBox.Show("Excel Application");
}
else if( application is Interop.Access.Application )
{
MessageBox.Show("Access Application");
}
You need to reference Interop.Excel, Interop.Access and System.Windows.Forms
for this example.
--
Rob Lorimer
Extreme Systems Ltd (NZ)
6. Determine type of control??
7. How Do I Determine Type of Graphic?
8. Having set label type, I cannot type in the address