A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Page Layout
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

change the Label Product Number to another one



 
 
Thread Tools Display Modes
  #1  
Old August 20th, 2004, 01:32 PM
Bert Mercado
external usenet poster
 
Posts: n/a
Default change the Label Product Number to another one

I have an exsiting Word Document in Lable Format (i.e., a
specific Label Product Number Has been chosen, thus
affecting pagelayout). How do I change the Label Product
Number to another one?

Thanks, Bert
  #2  
Old August 20th, 2004, 02:18 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default

There is no easy way to do this. Labels are set up as a table. If the
different label format you want to use has the same number of labels across,
you might be able to copy paste the text into the new format, but if there
is more than one page of labels, it is likely that the labels are the result
of a mail merge and will have section breaks between pages, meaning that
each page is a separate table. You could remove all the section breaks (Find
^ b and replace with nothing), then convert the resulting single table to
text, then back to a table with the right number of columns, then try to
paste into the label format, but this will probably give disappointing
results.

Your best bet is to create new labels with a mail merge. If the old labels
were merged and you can find the data source, you're in business. If not,
you can create a data source from the labels. There are various ways to do
this, but see
http://www.word.mvps.org/FAQs/MailMe...ToDatafile.htm for one
approach.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bert Mercado" wrote in message
...
I have an exsiting Word Document in Lable Format (i.e., a
specific Label Product Number Has been chosen, thus
affecting pagelayout). How do I change the Label Product
Number to another one?

Thanks, Bert


  #3  
Old August 20th, 2004, 02:25 PM
Jay Freedman
external usenet poster
 
Posts: n/a
Default

Bert Mercado wrote:
I have an exsiting Word Document in Lable Format (i.e., a
specific Label Product Number Has been chosen, thus
affecting pagelayout). How do I change the Label Product
Number to another one?


Hi Bert,

If the numbers of columns and rows per page are the same in both layouts,
you might try using the Table Properties dialog to change the cell size
and the table's offsets from the paper edges. This will probably become a
frustrating exercise.

Instead, convert your current batch of labels into a mail merge source
document, using the procedure Graham Mayor gives at
http://www.gmayor.com/convert_labels...mail_merge.htm. Then run a mail
merge to labels, where you can specify the product number for each run.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Office SP1 cannot install [email protected] Setup, Installing & Configuration 8 August 10th, 2004 03:40 PM
can't reinstall office xp pro after deleting from windows xp syste mkskyflyer Setup, Installing & Configuration 1 August 5th, 2004 05:39 AM
product number CHARLIE Setting up and Configuration 2 February 12th, 2004 11:26 PM


All times are GMT +1. The time now is 02:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.