Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-16-2019, 01:43 PM
Melissa Camp Melissa Camp is offline Windows 10 Office 2016
Novice
 
Join Date: May 2019
Posts: 7
Melissa Camp is on a distinguished road
Default Macro to populate 2 x 2 name tag; front and back

Hello!
I am hoping to be able to use a macro 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 spreadsheet.

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.

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 that person's assignment goes in the top right of the Back 'Allen Bagwell AM BACK' (aka position 2). The excel file could probably be re-ordered to accomplish this and then plugged in to the macro as usual.



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.

My inclination is this could also be done via mail merge, but I am so new to that function that I thought I would ask here first.
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)
  #2  
Old 05-16-2019, 03:31 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,392
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: http://www.msofficeforums.com/mail-m...ront-back.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]
  #3  
Old 05-16-2019, 08:30 PM
Melissa Camp Melissa Camp is offline Windows 10 Office 2016
Novice
 
Join Date: May 2019
Posts: 7
Melissa Camp is on a distinguished road
Default

sorry! Hoped to increase my chances of getting help. REALLY frustrated after working on this issue at length and just looking for a little assistance.
  #4  
Old 05-16-2019, 09:03 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,392
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 still need to decide on your preferred approach - and tell us...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
  #5  
Old 05-16-2019, 09:14 PM
Melissa Camp Melissa Camp is offline Windows 10 Office 2016
Novice
 
Join Date: May 2019
Posts: 7
Melissa Camp is on a distinguished road
Default

Delete this one.
Closed Thread

Tags
name card, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Triming a text selection front and back paik1002 Word 2 12-15-2015 10:11 PM
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM
Need help writing a macro to bring images to the front readheads Word 0 11-23-2013 07:37 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
Keep box drawn in front of Video in FRONT position a_gunslinger PowerPoint 1 04-18-2013 07:54 AM


All times are GMT -7. The time now is 11:03 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft