Hello...
I have set up a label merge between Word 2000 & an Excel
spreadsheet that I would like to start printing a list of
labels at a specific label on the sheet, 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 sheet. 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 sheet, 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
Peter Jamieson - 25 Jul 2004 10:44 GMT
> 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 sheet, open your Excel sheet, insert the appropriate number of blank
rows at the top, then depending on how Word is connecting to Excel, either
a. save the sheet under another name and merge from that or
b. (for DDE connections) merge from the sheet you opened, then use
Edit|Undo to remove the rows

Signature
Peter Jamieson
> Hello...
>
[quoted text clipped - 27 lines]
> Thanks,
> Mary Beth