Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2004

Tip: Looking for answers? Try searching our database.

Fill down instead of across

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MACC - 13 May 2004 18:51 GMT
In creating lables and catalogs I want to fill down instead of across and can't find where or how to do this.  No matter how I try or how many columns I set up it always fills across and then down.  I would appreciate any help!
Charles Kenyon - 13 May 2004 19:10 GMT
I believe that if you use snaking columns it will go down. That is, you do
not use a table for your columns. Just a shot in the dark.
Signature


Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> In creating lables and catalogs I want to fill down instead of across and can't find where or how to do this.  No matter how I try or how many columns
I set up it always fills across and then down.  I would appreciate any help!
Doug Robbins - Word MVP - 14 May 2004 06:14 GMT
This will do it for you.

' Macro to assign numbers to data source so that it can be sorted to cause
' labels to print down columns
Dim Message, Title, Default, labelrows, labelcolumns, i As Integer, j As
Integer, k As Integer
Message = "Enter the number of labels in a row"    ' Set prompt.
Title = "Labels per Row"    ' Set title.
Default = "3"    ' Set default.
' Display message, title, and default value.
labelcolumns = InputBox(Message, Title, Default)
Message = "Enter the number of labels in a column"    ' Set prompt.
Title = "Labels per column"    ' Set title.
Default = "5"    ' Set default.
labelrows = InputBox(Message, Title, Default)
ActiveDocument.Tables(1).Columns.Add
BeforeColumn:=ActiveDocument.Tables(1).Columns(1)
ActiveDocument.Tables(1).Rows(1).Range.Cut
k = 1
For i = 1 To ActiveDocument.Tables(1).Rows.Count - labelcolumns
   For j = 1 To labelrows
       ActiveDocument.Tables(1).Cell(i, 1).Range.InsertBefore k + (j - 1) *
labelcolumns
       i = i + 1
   Next j
   k = k + 1
   i = i - 1
   If k Mod labelcolumns = 1 Then k = k - labelcolumns + labelcolumns *
labelrows
Next i
ActiveDocument.Tables(1).Sort FieldNumber:="Column 1"
ActiveDocument.Tables(1).Rows(1).Select
Selection.Paste
ActiveDocument.Tables(1).Columns(1).Delete

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> In creating lables and catalogs I want to fill down instead of across and can't find where or how to do this.  No matter how I try or how many columns
I set up it always fills across and then down.  I would appreciate any help!
Bob S - 22 May 2004 19:39 GMT
>In creating lables and catalogs I want to fill down instead of across and can't find where or how to do this.  No matter how I try or how many columns I set up it always fills across and then down.  I would appreciate any help!

The easy way is to use the snaking columns feature.

Start the mail merge and let Word generate the label table. Write down
the width of the label cells and the width of the small cells that
Word uses to separate the columns of labels. Count the number of label
columns, select all the rows, and use Table | Insert Rows once for
each column of labels after the first. For example, Avery 5260 has ten
rows and three columns, so you would select all ten rows and use
Insert Rows twice, giving 30 rows of three columns.

The next step is to select all columns (including the little spacer
columns) except the first label column, and use Table | Delete
Columns. For the example we would now have 30 rows in one column.

Now invoke Format | Columns. Set the number of columns to be the
number of columns on the label sheet, set the column width equal to
the table cell width, and set the space between columns equal to the
width of the original spacer columns. For the example, we would have
three columns, the column width would be 2.625" and the space between
columns would be 0.125".

You now have a label setup that will order records down then across.
You can now continue with the merge.

Bob S
Doug Robbins - Word MVP - 23 May 2004 00:42 GMT
Or use the following macro

' Macro to assign numbers to data source so that it can be sorted to cause
labels to print down columns
Dim Message, Title, Default, labelrows, labelcolumns, i As Integer, j As
Integer, k As Integer
Message = "Enter the number of labels in a row"    ' Set prompt.
Title = "Labels per Row"    ' Set title.
Default = "3"    ' Set default.
' Display message, title, and default value.
labelcolumns = InputBox(Message, Title, Default)
Message = "Enter the number of labels in a column"    ' Set prompt.
Title = "Labels per column"    ' Set title.
Default = "5"    ' Set default.
labelrows = InputBox(Message, Title, Default)
ActiveDocument.Tables(1).Columns.Add
BeforeColumn:=ActiveDocument.Tables(1).Columns(1)
ActiveDocument.Tables(1).Rows(1).Range.Cut
k = 1
For i = 1 To ActiveDocument.Tables(1).Rows.Count - labelcolumns
   For j = 1 To labelrows
       ActiveDocument.Tables(1).Cell(i, 1).Range.InsertBefore k + (j - 1) *
labelcolumns
       i = i + 1
   Next j
   k = k + 1
   i = i - 1
   If k Mod labelcolumns = 1 Then k = k - labelcolumns + labelcolumns *
labelrows
Next i
ActiveDocument.Tables(1).Sort FieldNumber:="Column 1"
ActiveDocument.Tables(1).Rows(1).Select
Selection.Paste
ActiveDocument.Tables(1).Columns(1).Delete

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>
> >In creating lables and catalogs I want to fill down instead of across and can't find where or how to do this.  No matter how I try or how many columns
I set up it always fills across and then down.  I would appreciate any help!

> The easy way is to use the snaking columns feature.
>
[quoted text clipped - 21 lines]
>
> Bob S
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.