Mail Merge for ID

Care29 · #1 11-10-2024, 07:11 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a way to do a mail merge type of addition of data after a mail merge has been done?	mtandino	Word	4	06-01-2021 02:00 PM
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file	sureshbvs	Word VBA	1	03-12-2021 05:42 AM
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge	djrexy	Mail Merge	1	05-20-2020 04:04 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA	RMerckling	Mail Merge	16	05-17-2018 05:19 PM
Mail merge how to link mail merge field value to a column heading	dsummers	Mail Merge	1	05-08-2014 02:59 PM