Automatically filling out a form in Word

[zxarr]

Greetings,

I have just bought some cable labels from a company, who also sent me a 'template' for word that would allow me to print out what I wanted on a sheet. It's a simple arrangement of tables with 7 across and 6 down.

I need a way to fill out one page at a time with simple labels, but I need the labels printed in pairs. So, can anyone suggest a way to do this automatically? I'd like the labels to look like this:

B-0001 B-0001 B-0002 B-0002 B-0003 B-0003 B-0004

B-0004 B-0005 B-0005 B-0006 B-0006 B-0007 B-0007

This would continue until the end of the label sheet, which totals 42 labels per sheet.

One label for either end of a cable. I just need to tell Word what I want to start with (B-xxxx) and it should fill out the rest of the form.

Any ideas?

 

[xlhelp]

Create the numbers in Excel.

In Word, go to Tools, Mail Merge,

Select Create, Mailing Labels, Active Window

Select Get Data, Open Data Source, Check "Select Method" check box. Choose file type to be XLS. Select file, click Open.

Under confirm Data Source, select Microsoft Excel Worksheet via Converter. Click setup Main Document, Choose Label size, Insert the merge field.

Click on merge, New document

http://www.geniusmedia.ca