Re: Printing Merged labels starting at a specific sheet label

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Peter Jamieson (pjj_at_KillmapSpjjnet.demon.co.uk)
Date: 07/25/04

  • Next message: Peter Jamieson: "Re: mail merge to Lotus Notes email?" 
    Date: Sun, 25 Jul 2004 10:44:03 +0100

    > I hate to say it, but "WordPerfect" could do this in a
    > snap. Can Word rise to the challenge?!

    :-) I doubt it, without coding effort.

    IMO the very simplest way to approach this, if you are always doing the
    merge yourself and are willing to jump through a couple of extra hoops, is
    probably to work out how many "blank" labels you need at the to pof the
    first ***, open your Excel ***, insert the appropriate number of blank
    rows at the top, then depending on how Word is connecting to Excel, either
     a. save the *** under another name and merge from that or
     b. (for DDE connections) merge from the *** you opened, then use
    Edit|Undo to remove the rows 

    -- 
Peter Jamieson
"Mary Beth" <anonymous@discussions.microsoft.com> wrote in message
news:2d6001c470be$6ee6e7a0$a301280a@phx.gbl...
> Hello...
>
> I have set up a label merge between Word 2000 & an Excel
> spread*** that I would like to start printing a list of
> labels at a specific label on the ***, i.e. 3rd label in
> the first row, etc.
>
> I can set up Macros to insert cells and rows to move the
> labels to my preferred starting label position, but this
> puts the labels out of numeric order, which are
> sequentially numbered for reference purposes, and leaves
> empty labels further down the ***.  These labels are
> being transferred to boxes & vials containing specimens of
> the referrenced numbers, and it would help to be able to
> keep the sequential order on the label ***, despite where
> the first label starts printing.
>
> I've tried "selecting all" to see if I could move the
> entire group to start in the cell I would prefer, but then
> I lose the label format.  I've also discovered that labels
> don't "wrap" around and down, but instead end up outside
> the formatted table.  I've tried starting a merge in the
> preferred cell/label position, but then subsequent pages
> also merge to the same cell/label position, leaving the
> labels in-between blank.
>
> I hate to say it, but "WordPerfect" could do this in a
> snap.  Can Word rise to the challenge?!
>
> Thanks,
> Mary Beth
  • Next message: Peter Jamieson: "Re: mail merge to Lotus Notes email?"
    • Quantcast