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 / General MS Word Questions / April 2004

Tip: Looking for answers? Try searching our database.

Duplexing labels.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
joe hagerty - 30 Apr 2004 03:57 GMT
I am in need of doing a mail merge unto business cards.  Unfortunately they
also need to be double sided... The Mail merge is working fine for the
front, but for the back, I need to reverse the two columns so that they are
printed correctly.

Can anyone give me any suggestions on how to configure the merge fields to
make that happen?

Thanks

Joe Hagerty
Tentmakers Missionary Fellowship
Doug Robbins - Word MVP - 30 Apr 2004 06:36 GMT
Hi Joe,

If the datasource is a Word document, if you run the following macro on that
document, it will sort it so that the two columns would be reversed.

Dim Message, Title, Default, labelrows, i As Integer, j As Integer, num As
Range
' Display message, title, and default value.
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
For i = 1 To ActiveDocument.Tables(1).Rows.Count
   Set num = ActiveDocument.Tables(1).Cell(i, 2).Range
   num.End = num.End - 1
   j = Val(num)
   Select Case i Mod 10
       Case 1 To 5
           ActiveDocument.Tables(1).Cell(i, 1).Range.InsertBefore j +
labelrows
       Case 6 To 9
           ActiveDocument.Tables(1).Cell(i, 1).Range.InsertBefore j -
labelrows
       Case Else
           ActiveDocument.Tables(1).Cell(i, 1).Range.InsertBefore j -
labelrows
   End Select
       MsgBox "OK"
Next i
ActiveDocument.Tables(1).Sort FieldNumber:="Column 1"
ActiveDocument.Tables(1).Rows(1).Select
Selection.Paste
ActiveDocument.Tables(1).Columns(1).Delete

If the datasource is not a Word document, use a Catalog or DIrectory type
mailmerge to create a document containing a table with the records in it,
then insert a row at the top of the table for the field names and then run
the macro.

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

> I am in need of doing a mail merge unto business cards.  Unfortunately they
> also need to be double sided... The Mail merge is working fine for the
[quoted text clipped - 8 lines]
> Joe Hagerty
> Tentmakers Missionary Fellowship
 
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.