Good day!
I am hoping somebody can help with my mail merge inquiry. I am trying to print IDs using MS Word. I separated the file for the front and back of the ID and there should be 3 sets of IDs per file.
The back part of the ID should be in a different order than the front. Please see the sample below.
1 2 3
6 5 4
I have seen one solved thread that used a macro, but it only worked for 2 columns. See the macro codes below for reference.
Code:
Sub MailMergeToDoc()
Application.ScreenUpdating = False
Dim Tbl As Table
ActiveDocument.MailMerge.Execute
For Each Tbl In ActiveDocument.Tables
With Tbl
.Columns(2).Select
Selection.Copy
.Columns(1).Select
Selection.Paste
.Columns(3).Delete
End With
Next
Application.ScreenUpdating = True
End Sub
Thank you in advance.