Microsoft Office Forums Using mail merge to print labels

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-10-2016, 02:54 PM
scooterspal scooterspal is offline Using mail merge to print labels Windows XP Using mail merge to print labels Office 2000
Novice
Using mail merge to print labels
 
Join Date: Mar 2016
Posts: 4
scooterspal is on a distinguished road
Default Using mail merge to print labels

Hello to all and thanks for any help you can provide me...

I have Office 97. Trying to use Word to print some mailing labels from an Excel spreadsheet.

I can get the mail merge to work OK and the names and addresses appear but what I have set up on the labels goes away.

I want to place some information (same for each) like return address and a line of information on each label and have the individual address print in the center. Can this be done or must I print each part separately?

Thanks!
Reply With Quote
  #2  
Old 03-10-2016, 08:48 PM
macropod's Avatar
macropod macropod is offline Using mail merge to print labels Windows 7 64bit Using mail merge to print labels Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You need to do the setup for the first label, so as to get the required layout. Use the merge preview to confirm. IIRC, Word 97 has an 'update labels' button, which will then propagate the first label's layout & content to all the other labels. you should then be able to run the merge and get the correct output.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 03-11-2016, 09:19 AM
scooterspal scooterspal is offline Using mail merge to print labels Windows XP Using mail merge to print labels Office 2000
Novice
Using mail merge to print labels
 
Join Date: Mar 2016
Posts: 4
scooterspal is on a distinguished road
Default

Thanks for the reply.

There is no "update labels" button or anything like that that I can find in Word 97.

The only way I can add text to the labels (there are 6 on a page) is to first do the mail merge and get the names to appear. Then open a text box and add some text.

That works and it will print there but I find no way to copy that to the other labels.
I'd have to retype for every single one.

Suggestions?
Reply With Quote
  #4  
Old 03-11-2016, 02:06 PM
macropod's Avatar
macropod macropod is offline Using mail merge to print labels Windows 7 64bit Using mail merge to print labels Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The process for Word 97 is described at: https://support.microsoft.com/en-us/kb/141992. It seems in that version you should only need to use the 'Create Label' dialog box to define a 'Sample Label' and Word will take care of the rest. See under 'Step 3: Edit Main Document'.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 03-11-2016, 03:50 PM
scooterspal scooterspal is offline Using mail merge to print labels Windows XP Using mail merge to print labels Office 2000
Novice
Using mail merge to print labels
 
Join Date: Mar 2016
Posts: 4
scooterspal is on a distinguished road
Default

Just not going to work, I don't think.

Followed the directions to the letter. Yes, I can add some extra text in the dialog when I set up the fields (I assume this is what they mean) and it will put that text on every label with the individual address but...

Really no way to edit the format. Can change the point size from the default set before the merge and sort of adjust spacing using the space bar between lines... but that only gets me the first label. The others remain the same.

Looks like this old version does not have the ability to do this. Perhaps a standalone mailing label program is what I need to look for.

That, or I need to print all the pages with my return address and additional line of text first, then rerun the sheets a second time for the addresses. That will work... but I'm afraid another pass on the laser printer will cause the sheets to curl and jam up.

Thanks for the help. If you have any other ideas I will surely try them.
Reply With Quote
  #6  
Old 03-11-2016, 04:00 PM
macropod's Avatar
macropod macropod is offline Using mail merge to print labels Windows 7 64bit Using mail merge to print labels Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You do all the format editing in the dialogue, not in the labels; otherwise you'll need to copy the first label, then paste it over the other labels then add a 'next record' field to the start of every label except the first.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 03-12-2016, 09:50 AM
scooterspal scooterspal is offline Using mail merge to print labels Windows XP Using mail merge to print labels Office 2000
Novice
Using mail merge to print labels
 
Join Date: Mar 2016
Posts: 4
scooterspal is on a distinguished road
Default

Well, tried as you suggested.

Yes, if I add the return address to the top and the additional line of text I want to appear to the bottom in the set up dialog and place the fields between these then all of it appears on the labels after the merge.

The issue, for me at least, is that it is all the same point size and the layout not to my liking.

Would prefer to be able to set up the master label with different font and point size and position it better. Also was hoping to add a small graphic that says "peel" to the corner. Cannot do that in '97, apparently.

What you suggest work, though, and I thank you for that
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using mail merge to print labels Help with a mail merge onto labels dhause211 Mail Merge 1 07-14-2014 09:36 PM
Mail merge is duplicating labels CathyLewis Mail Merge 4 05-26-2014 11:54 PM
Using mail merge to print labels Mail Merge Adds Labels LRCote Mail Merge 1 10-05-2010 06:52 AM
Mail Merge - Labels borislibman Mail Merge 0 12-13-2009 07:24 PM
Labels Mail Merge borislibman Outlook 0 12-13-2009 07:23 PM


All times are GMT -7. The time now is 03:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft