Dkso
Wed Feb 02 15:10:23 CST 2005
Doh!
Thanks
"RagDyer" <ragdyer@cutoutmsn.com> wrote in message
news:us73zQWCFHA.3592@TK2MSFTNGP09.phx.gbl...
> You're *definately* going about it the "long" way.
>
> All you need is a standard XL datalist, and then use Word to do the
> formatting and printing of the actual labels.
> All you need to know can be found at David McRitchie's extensive web page
> on
> the subject.
>
>
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Dkso" <dkso@ntlworld.com> wrote in message
> news:e0mGYIWCFHA.1392@tk2msftngp13.phx.gbl...
> I have an Excel spreadsheet that uses a query to get info from the
> database,
> this info is held in a list, each item is a replenishment available to be
> done. I want to be able to re-produce this list on a separate sheet but 4
> at a time so they can be printed on sticky labels.
> Using a straight forward cell reference I have the fist 4 items but I
> can't
> figure out how to move the cell reference down by 4 so as to print the
> next
> 4.
>
> Am I going about it the long way?
> The list will change in length so I'll need to check and stop at the end
> of
> the list.
>
> Ideas or help appreciated.
>
> Dean
>
>