Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 05-16-2019, 10:29 PM
macropod's Avatar
macropod macropod is offline Mail merge to create name tag front and back Windows 7 64bit Mail merge to create name tag front and back Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,520
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For the mailmerge basics, see: Mail merge using an Excel spreadsheet - Microsoft Support

For PC macro installation & usage instructions, see: Installing Macros
For Mac macro installation & usage instructions, see: https://wordmvp.com/Mac/InstallMacro.html

Here's a superior version of the macro that avoids the copy/paste overhead and will work with any number of labels across the page:
Code:
Sub MailMergeToDoc()
Application.ScreenUpdating = False
Dim Tbl As Table, Rng As Range, c As Long
ActiveDocument.MailMerge.Execute
For Each Tbl In ActiveDocument.Tables
  With Tbl
    For c = .Columns.Count - 1 To 1 Step -1
    .Columns.Add
    Set Rng = .Columns(c).Cells(1).Range
    Rng.End = Rng.End - 1
    .Columns.Last.Cells(1).Range.FormattedText = Rng.FormattedText
    .Columns(c).Delete
    Next
  End With
Next
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
 

Tags
name card



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge to create name tag front and back Mail Merge does not split tables if entry has a number in front B-Man Mail Merge 5 05-19-2019 07:25 AM
Mail merge to create name tag front and back Macro to populate 2 x 2 name tag; front and back Melissa Camp Word VBA 4 05-16-2019 09:14 PM
Mail merge to create name tag front and back Triming a text selection front and back paik1002 Word 2 12-15-2015 10:11 PM
2010 Mail Merge Directory how to print back-to-back w/2 pages per sheet captaintms Mail Merge 4 08-13-2015 06:21 AM
Mail merge to create name tag front and back Is there a way to print only certain pages in a document front to back? GrahamV2 Word 2 06-26-2013 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft