#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
This is essentially a duplicate of: https://www.msofficeforums.com/mail-...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 [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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
|
||||
|
||||
You still need to decide on your preferred approach - and tell us...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Delete this one.
|
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 |