Microsoft Office Forums Mail merge to create name tag front and back

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2019, 01:51 PM
Melissa Camp Melissa Camp is offline Mail merge to create name tag front and back Windows 10 Mail merge to create name tag front and back Office 2016
Novice
Mail merge to create name tag front and back
 
Join Date: May 2019
Posts: 7
Melissa Camp is on a distinguished road
Default 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
Attached Files
File Type: docx Allen - Bagwell AM.docx (12.6 KB, 0 views)
File Type: doc Allen Bagwell AM BACK.doc (36.0 KB, 0 views)
File Type: xlsx SP19 Marshals - Morning Alpha (1).xlsx (12.7 KB, 0 views)
Reply With Quote
  #2  
Old 05-16-2019, 03:31 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: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-16-2019, 09:48 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: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
Clicking on the 'Edit Individual Documents' button will intercept the merge, finishing it and re-arranging the output.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 05-16-2019, 10:01 PM
Melissa Camp Melissa Camp is offline Mail merge to create name tag front and back Windows 10 Mail merge to create name tag front and back Office 2016
Novice
Mail merge to create name tag front and back
 
Join Date: May 2019
Posts: 7
Melissa Camp is on a distinguished road
Default

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!
Reply With Quote
  #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: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #6  
Old 05-17-2019, 11:50 AM
Melissa Camp Melissa Camp is offline Mail merge to create name tag front and back Windows 10 Mail merge to create name tag front and back Office 2016
Novice
Mail merge to create name tag front and back
 
Join Date: May 2019
Posts: 7
Melissa Camp is on a distinguished road
Default

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!
Reply With Quote
  #7  
Old 05-17-2019, 03:00 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: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Everything you have asked for has been addressed. You need to invest some effort implementing it.
As for
Quote:
Originally Posted by Melissa Camp View Post
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."
all that goes to show is that you haven't even tried.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #8  
Old 05-20-2019, 09:15 AM
Melissa Camp Melissa Camp is offline Mail merge to create name tag front and back Windows 10 Mail merge to create name tag front and back Office 2016
Novice
Mail merge to create name tag front and back
 
Join Date: May 2019
Posts: 7
Melissa Camp is on a distinguished road
Default

This macro totally worked. Thank you for your help, it was easier than I expected.
Reply With Quote
Reply

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
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


All times are GMT -7. The time now is 03:57 AM.


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