Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2017, 01:37 AM
Loudacrish Loudacrish is offline Fitting Photos into Avery Labels Using Fitted Text Boxes Mac OS X Fitting Photos into Avery Labels Using Fitted Text Boxes Office 2016 for Mac
Novice
Fitting Photos into Avery Labels Using Fitted Text Boxes
 
Join Date: Jun 2017
Posts: 2
Loudacrish is on a distinguished road
Default Fitting Photos into Avery Labels Using Fitted Text Boxes

Good Morning,

I work for an artist, and she needs to have contact sheets of her photos (and titles/other information) printed onto labels. I have got the Avery template, and my first go was to use developer frames, which seemed great for landscape photos, but portrait photos would extend down into the next label. Not satisfactory. I then tried text boxes, which seem to work better, but it is still necessary to rejig the photos a bit when they're in.

What I would like to find is a way to set up a frame as a template, for each of the 14 labels on the page. Each one would automatically resize the picture that was dragged into it, so that it would not extend into the next label. Is it possible to do this? I've tried setting the parameters, mucking around with locking anchors and all that, but I'm afraid I don't know an awful lot when it comes to specific tasks like this.



Any help would be much appreciated,
Kind Regards,
Lou.
Reply With Quote
  #2  
Old 06-16-2017, 03:38 AM
gmayor's Avatar
gmayor gmayor is offline Fitting Photos into Avery Labels Using Fitted Text Boxes Windows 10 Fitting Photos into Avery Labels Using Fitted Text Boxes Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,623
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

If you insert a picture in line into a label table cell the image will shrink to the width of the cell. A text box is superfluous.

You may find http://www.gmayor.com/photo_gallery_template.html useful.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 06-16-2017, 12:55 PM
Loudacrish Loudacrish is offline Fitting Photos into Avery Labels Using Fitted Text Boxes Mac OS X Fitting Photos into Avery Labels Using Fitted Text Boxes Office 2016 for Mac
Novice
Fitting Photos into Avery Labels Using Fitted Text Boxes
 
Join Date: Jun 2017
Posts: 2
Loudacrish is on a distinguished road
Default

thank you for your help
Reply With Quote
Reply

Tags
autofit, labels, template

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Avery Labels Centering lostsoul62 Word 2 11-09-2012 02:55 PM
Fitting Photos into Avery Labels Using Fitted Text Boxes Having trouble with Avery labels bcircus Word 1 11-09-2012 12:49 PM
Fitting Photos into Avery Labels Using Fitted Text Boxes Avery Labels city gent Word 2 11-06-2012 02:58 PM
Avery Labels Numbered 1 through 1000+? kteh54 Word 0 03-03-2010 06:06 PM
Fitting Photos into Avery Labels Using Fitted Text Boxes avery labels janey Word 3 02-27-2006 11:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:57 AM.


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