Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2022, 12:38 PM
WhyDoINeedAnAccount WhyDoINeedAnAccount is offline Mail Merge and Text Boxes Windows 8 Mail Merge and Text Boxes Office 2013
Novice
Mail Merge and Text Boxes
 
Join Date: Jul 2022
Posts: 1
WhyDoINeedAnAccount is on a distinguished road
Default Mail Merge and Text Boxes


Hi all,

I am trying to create a template for name tents and it is proving to be much more difficult than I expected. I need them to be double sided which means the first field for each tag MUST BE upside down text. This is not possible with tables so I am stuck using text boxes to flip it over (something I wish I didn't have to do, it's akin to merging cells in Excel in my opinion). What I need is for the first name to populate in the first two text boxes, the next name to populate in the next two boxes and so on...Ideally this is done with a mail merge rather than manually typing/copy pasting 30+ names 2x each

Currently I have built a table that aligns exactly with our special tent card paper (avery 5305 whose template is useless and not accurate) and prints everything in the right location. The text boxes are inside the table because it made formatting easier - not even sure how I would get exact spacing without a table honestly. Everything is hunky dory til I try to add the mail merge step.

It refuses to allow "next record" in a text box. So I get the same name populated over and over. I've tried putting "next record" in the table itself, above the next text box, and it doesn't seem to recognize it. I am absolutely stumped as to how I'm supposed to make this work.

I have attached the file. The first page shows what I need it to look like when complete and the second page shows where I currently am with the mail merge steps. Any insight/help would be greatly appreciated (like maybe a way to type upside down in tables?). The formatting MUST stay exactly the same (margins, cell size, text box size, etc.)

TLDR: need double sided name tents and would prefer to mail merge the names into place rather than typing them out
Attached Files
File Type: docx Mail Merge Test.docx (30.8 KB, 6 views)
File Type: xlsx Mail Merge Tent Card Test.xlsx (8.7 KB, 5 views)
Reply With Quote
  #2  
Old 07-12-2022, 01:48 PM
macropod's Avatar
macropod macropod is offline Mail Merge and Text Boxes Windows 10 Mail Merge and Text Boxes Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,719
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Have you tried changing the page layout to landscape, with a 4-column table - which would allow you to use the table text orientation to achieve the flipped text you require?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge and Text Boxes Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content Alfred Mail Merge 2 05-23-2017 10:59 PM
Mail Merge and Text Boxes Drawing lines between text boxes which have actual text within the text boxes RHODIUM Word 6 10-01-2016 04:43 PM
How to merge text boxes in a large imported document boatfly Word 3 04-20-2016 06:15 AM
Mail merge, text boxes, and two documents per sheet! MelissaAnnie Mail Merge 2 09-24-2014 03:46 PM
Word2010 check boxes and plain text content control boxes in same table fcsungard Word 5 06-01-2012 01:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:14 AM.


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