Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I insert Excel values in Word labels without mailmerge?
I'm printing theatre section, row and seat numbers on clear return address
labels to apply to tickets for an event. I have to print 2 copies of each label. Since the Avery template only uses half of the available labels I inserted a table using the Avery specs. The seating information is in an Excel workbook spreadsheet. Col A is all the sections, rows and seats in the Orchestra section, col B duplicates col A, Col C has the Mezzanine seating info & col D duplicates col C. Each cell has all the info concatenated from other sheets in that workbook so I don't have to add any text to the label except the final value in each cell. The labels are arranged in landscape so there are 20 columns with 4 printable rows. (Rows 2, 4 & 6 are spacers on the label sheet.) I'm open to any suggestions including rearranging the spreadsheet, etc. I get some pretty strange results when I try to use mail merge but if there's a way to make that effective, that works for me, too. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help | |||
Why isn't all my Excel data merging into my Word labels document? | Mailmerge |