 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Publisher / Programming / September 2005How do I merge two data fields on 1 page?
I am trying to use Publisher to create medium sized front and back table tents (the name needs to appear on the front and back) I am usign Avery 5305 Card Stock. 2 cards can be printed per piece of card stock. I want to use use a mail merge from excell spread sheet. The name repeats twice for each card (front and back, the second appears upside down). I can successfully merge the data into the form, and have it appear the way I want it to, but I cannot get it to print two pages (of data) on the one page. Instead of printing the name field twice, it prints it four times. I've tried changing the layout, setting up separate pages. I found a template for the card 5305 in Word, downloaded it from the Avery site but I can't figure out how to set up the form, no way to see the coding or add Borders, etc. Please help. Can you do a merge in Powerpoint? Avery has two different templates for your card number. Publisher has the template in the label list. I tried merging with this setup, it doesn't work... You'll probably have to manually do your cards. Create a text box, type the text, rotate, adjust to fit the space. Copy, paste, rotate 180 degrees and place in the next space. The setup in Publisher would be if you are using the front/back template, page setup landscape, on the arrange menu top - 0.5 side -1.0 grid guides 4 columns, 1 inch spacing.  SignatureMary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com >I am trying to use Publisher to create medium sized front and back table > tents (the name needs to appear on the front and back) I am usign Avery 5305 [quoted text clipped - 8 lines] > up the form, no way to see the coding or add Borders, etc. > Please help. Can you do a merge in Powerpoint? Okay, I figured it out. You need two fields in your Excel database. Column A and Column B. Merge column A into the first two columns in the previous posted setup, rotate each, the first facing left... Merge column B into the third and fourth column, the third column facing left... This means separating your excel data into two columns. SignatureMary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com > Avery has two different templates for your card number. Publisher has the template > in the label list. I tried merging with this setup, it doesn't work... [quoted text clipped - 21 lines] >> up the form, no way to see the coding or add Borders, etc. >> Please help. Can you do a merge in Powerpoint? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.