File Folder labels printing

[lazarusworks]

I am trying to print labels in order to organize our file system better. there are four types of information that will appear on each label corresponding to four columns in a work sheet. i have tried to do it through mail merge but i t won't set up right . i want it to be 2 lines on label . top line woulbd be a company name left justified and a machine type right justified the second line would be set up the same. mail merge won't allow me to do this . can anyone help ? can it be done through excel alone ? i am working off office 97.

 

[Frank Kabel]

Hi
thisn should be possible using Word (97). But you may post this
question 8as this seems to be a Word formating question) in the MS Word
NG

--
Regards
Frank Kabel
Frankfurt, Germany

I am trying to print labels in order to organize our file system

better. there are four types of information that will appear on each
label corresponding to four columns in a work sheet. i have tried to do
it through mail merge but i t won't set up right . i want it to be 2
lines on label . top line woulbd be a company name left justified and
a machine type right justified the second line would be set up the
same. mail merge won't allow me to do this . can anyone help ? can
it be done through excel alone ? i am working off office 97.

 

[Debra Dalgleish]

It would be best to set this up in Word, and use the Mail Merge to pull the data from Excel.

In Word, start the Mail Merge, and in step 2, select the Excel document as the data source
In the Mail Label setup, insert the first field, then type a couple of plus signs
Insert the next field for the first line, then press the Enter key to start a new line
Do the same on the next line. Your label should look like this (with your field names):
«MergeField1»++«MergeField2»
«MergeField3»++«MergeField4»
Click OK, then Close
Select all the columns in the table of labels
Choose Format>Tabs
Type a tab stop position, e.g. 2.5
Select Right, click OK
Choose Edit>Replace
For 'Find What', enter: ++
For 'Replace With', enter: ^t
Click Replace All
Close the Replace dialog box, and finish the Merge.