Re: Contact List in Excel - Printing Labels in Word

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Laura,

Take your Excel list and hide rows 2 to 4 and 31 to the end. Then Save your
Excel workbook. When you print the labels in Word it shouldn't see the
hidden rows.

CHORDially,
Art Farrell

"Laura" <Laura@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:406E2303-BE4D-4BE0-AA1C-979135F8243E@xxxxxxxxxxxxxxxx
I have a contact list in Excel which consists of 400 names and addresses.
I
have successfully "mail merged" these into Word for label printing. Now I
would like to know if Excel/Word is capable of printing only a selection
of
those 400 contacts? For instance, if I need labels for the contacts in
row 5
thru 30, is there a way to only select contacts in row 5 thru 30 before
the
mail merge is executed?

Thanks.


.

Relevant Pages

  • Re: Label alignment with Mail Merge
    ... labels that previously lined up with labels no longer do when printed. ... On printing addresses creep up the page. ... correct label identified in Mail merge selection and it worked in the past ...
    (microsoft.public.windowsxp.newusers)
  • RE: address database question
    ... I think I'm okay so far, unless I have trouble printing the labels. ... I should have separate columns for type and "x" in the appropriate one, ... The shading and cell outlines (lightly around all edges ...
    (microsoft.public.excel.newusers)
  • Merge Labels Printing Blank Lines
    ... The final product is printing out blank ... >labels - nothing about suppressing blank lines. ... >Kenwood Psychological Services ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mailmerge Label printing
    ... I was manually feeding the labels. ... > I regularly mail out to many people, I use Excel as the data file. ... I keep having to press the online button on the printer. ... > printing several hundred labels, ...
    (microsoft.public.word.printingfonts)
  • Re: address database question
    ... If you use word to print the labels you better use separate columns to indicate categories with a simple "x" or something. ... It's a little slow on input but makes the selecting and printing very easy. ... So - Person A would have 3 rows, all the same, except for the Type Code? ...
    (microsoft.public.excel.newusers)