![]() |
#1
|
|||
|
|||
![]()
Hello
I have an issue creating a custom size "price tag". I have perforated paper with strips and columns. 3 columns, 3.5" wide and 6 rows, 1.25" tall. There is a margin of .5' on top and bottom of sheet. I want to import excel data into specific areas inside the individual tags. I also want different logos inside each tag. Ideally each tag will have a logo, product name, and price field. I want to keep the excel file updated and import it directly into any program that can automate this process for me. Any ideas would be GREATLY APPRECIATED. I have been playing with tons of different options and no luck. Thanks Shaun |
#2
|
||||
|
||||
![]()
What you're describing is a label merge. If there isn't a pre-defined label available that meets your specifications, you could create a table that does satisfy them. From there, it's simply a matter of using the mailmerge tools to connect the document to Excel and inserting the required mergefields on the first label and formatting its layout the way you want them to appear. Once you've done that, clicking 'update labels' will propagate the fields and layout to the remaining cells. For variable graphics, see the Mailmerge Tips and Tricks thread at:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
Tags |
automated, insert data, tags |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using document shelf (I think that was name) | IanDB | Word VBA | 3 | 09-13-2015 01:09 AM |
![]() |
Nisio07 | Excel | 2 | 09-30-2014 01:16 PM |
![]() |
tombradley | Mail Merge | 1 | 09-29-2013 07:35 PM |
![]() |
jbk1043 | Word | 1 | 03-03-2013 01:46 PM |
![]() |
p3aul | Word | 9 | 08-18-2009 12:42 AM |