Select which labels print in mail merge

[Kojak43]

I have a small Excel file that contains information I want to place on a label.
I thought I could use Word's MailMerge>Labels. I set up the fields I want to get from Excel on the label.

I also included common text that describes the data that Excel leaves behind. i.e. "Contents of this Carton" is what I wrote. Excel then places the information adjacent.

2 problems. One is the common text prints on all the labels, even though I may only want to print 8 of them this time and 3 of them next time that has the Excel data. Problem 2 is I can not select which label prints. i.e. Column 2 Row 4.

I did press Replicate Labels and that put all the common text on the labels. But If I don't, I'll end up having to format each label individually. I then tried to delete all labels except those where I actually had a live label (not a blank space from a previously used label) and that did not work at all. In fact nothing would print. I had to backout and reformat the label.

I am using Excel/Word 2003.

I am certain you all can help. I've never been let down before!
k

 

[BlueHorizon]

Hi,
If I understand your question....
Using Word's Mail Merge Task Pane (View/Task Pane/Mail Merge):
In Step 3 of the Wizard, you can select and edit the data source, which means you can select which labels you want. You can select those labels which require the extra text first and print just those.
Then, go back to Step 3 and select those labels which do not require the extra text and print only those.

HTH,

Best,
Blue Horizon

http://www.bluehorizontraining.com