Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2017, 02:07 PM
macropod's Avatar
macropod macropod is offline I have a very specific need but don't know how to do it... Windows 7 64bit I have a very specific need but don't know how to do it... Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your attachment in post #5 is a plain text file, not a Word document, so I can only assume the structure is the same.

Achieving your desired outcome will take some work to do, but it is possible. For the layout indicated in your 1.jpg:-
1. Insert your content into a document with your page size, oriented in landscape format.
2. Set the page margins to: top=4.8mm; bottom=4.8mm; left=7.5mm; right=7.5mm.
3. Set the page layout to 5 columns, with 0 space between the columns. This will give a column width of 61mm.
4. Using a wildcard Find/Replace, choose:
a) Find = ^13
Replace = ^l


b) Find = ^l^l
Replace = ^p
c) Find = ^32CEP
Replace = ^lCEP
d) Find = (CEP=[0-9\-]@)^32
Replace = \1^l
5. Select all (Ctrl-A), then choose Insert|Table>Convert text to table>OK.
6. With the table remaining selected, choose Table Tools|Layout|Properties>Table>Alignment:Center>Opt ions Left:0, Right:0, 'Automatically resize to fit contents':unchecked>OK>Row>Specify Height>41mm>Row height is:Exactly>'Allow row to break across pages':unchecked>OK>Column>Preferred width:61mm

At this stage, all the label setup work will be done. You will still need to do things like setting paragraph format, font name & size, and so on.

Some of the longer lines will probably have text-wrapping where you don't want it, so you'll have to either break those lines manually or change their font name & size so they fit. This part really can't be simplified.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 11-12-2017, 05:32 PM
Bugfinder Bugfinder is offline I have a very specific need but don't know how to do it... Windows 7 64bit I have a very specific need but don't know how to do it... Office 2016
Novice
I have a very specific need but don't know how to do it...
 
Join Date: Nov 2017
Posts: 6
Bugfinder is on a distinguished road
Default

Hi Paul, thank you for your great help! You taught me how to do it, thanks a lot. I noticed that the text ended being too close to the frame border, so in the table properties, instead of putting 0 for left and right, I chose to write 0.3 cm each, plus 0.3 cm on top. This insured there was no possibility of text accidentaly being printed too close to the label cutline and letters from one label touching the letters of the labels on either sides.

May I ask you one more instruction? In the example I sent here, there were no extra spaces at the end of lines. But in the rest, there are some addresses with useless spaces. Like this:

ADDRESS[ _______________ ]end of line <<< lots of spaces

This causes a problem because some addresses ended mixed together. What are the find/replace strings to delete extra spaces at the end of each line, no matter if 1 or 10? And most importantly, at which point should this find/replace be done? Before or after step 4a?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert specific picture and add specific Text to it Syasthe Word VBA 1 11-02-2017 02:08 AM
Have a very specific requirement ggoffice000 Excel Programming 2 02-03-2017 03:47 PM
Print attachment when it arrive in specific folder with specific subject visha_1984 Outlook 1 01-30-2013 10:42 AM
I have a very specific need but don't know how to do it... Specific Hyperlink dextrousdave Word 1 01-16-2012 09:10 PM
I have a very specific need but don't know how to do it... Looking for a specific spreadsheet DivideByZer0 Excel 3 11-10-2009 05:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:35 PM.


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