![]() |
|
#5
|
||||
|
||||
|
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 does not split tables if entry has a number in front
|
B-Man | Mail Merge | 5 | 05-19-2019 07:25 AM |
Macro to populate 2 x 2 name tag; front and back
|
Melissa Camp | Word VBA | 4 | 05-16-2019 09:14 PM |
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 |
Is there a way to print only certain pages in a document front to back?
|
GrahamV2 | Word | 2 | 06-26-2013 10:38 AM |