#1
|
|||
|
|||
Mail merge to create name tag front and back
Hello!
I am hoping to be able to use mail merge to populate name tags in MS Word with first and last names on the front and roles and schedule on the back. The names and roles are listed in an excel spreadshee There are two word docs, the one labelled 'Allen Bagwell AM' is the front of the name tag, the word doc labelled 'Allen Bagwell Back' is the back of the tag. The word docs both contain four name tags per sheet in a 2 x 2 grid format. The excel sheet contains the names and assignments of each individual in the ceremony. Here is the catch, the 'AM Bagwell back' DOC must be populated in a different order than the front. The layout of the front is given below. The numerals 1-4 represent the first four names on the excel sheet (rows 4-7). 1 2 3 4 To ensure the back of the name tag is accurate and contains the role of the person listed on the front it should be populated in a different order the back would be populated as 2 1 4 3 This means that the first name on the Excel spreadsheet (row 4) goes in the top left of the word doc 'Allen Bagwell AM' (position 1) but the corresponding assignment goes in the top right of the Back 'Allen Bagwell AM BACK' (position 2). The assignments are listed in column 'C' and they go above the Schedule of Events in the 'Allen Bagwell AM BACK' doc. The schedule of events should remain unchanged. I would like if the macro could populate just one sheet at a time as I must save each sheet with a certain label. The alternative to this would be to create one large MS Word doc with all 83 names as the front doc and a separate doc with all 83 assignments for the back. I am pretty new to mail merge, so detailed instructions are appreciated. Thank you in advance! Melissa |
#2
|
||||
|
||||
This is essentially a duplicate of: https://www.msofficeforums.com/word-...-name-tag.html
Kindly don't waste peoples' time by seeking two different solutions to the same problem. Choose the approach you want to take and ask for such help as you need with that approach.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
You could simply add the following macro to the mailmerge main document that's supposed to output the second version:
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Thank you for this part. I gather this code will help me overcome the mirror image issue. But I am afraid I need more instructions; a straightforward spelling out or list of what I need to do including mail merge steps and macro-incorporating would be really appreciated. Thank you!
|
#5
|
||||
|
||||
For the mailmerge basics, see: https://support.office.com/en-us/art...B-0A948FA3D7D3
For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm For Mac macro installation & usage instructions, see: https://wordmvp.com/Mac/InstallMacro.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
Thank you for these. They are not really what i needed, but they are good resources and I have gone through all three.
If it's not too much trouble, I do still need help specific to my question and specific to your answer. For one thing I am not sure what's meant by "Clicking on the 'Edit Individual Documents' button will intercept the merge, finishing it and re-arranging the output." Again, if you could address what i attached and tell me what you would do in more detail. Thank you in advance! |
#7
|
||||
|
||||
Everything you have asked for has been addressed. You need to invest some effort implementing it.
As for all that goes to show is that you haven't even tried.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#8
|
|||
|
|||
This macro totally worked. Thank you for your help, it was easier than I expected.
|
Tags |
name card |
Thread Tools | |
Display Modes | |
|
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 |