Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2018, 02:10 PM
macropod's Avatar
macropod macropod is offline Pictures! Windows 7 64bit Pictures! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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

The only way to enlarge an undersize picture is to do so manually or via a macro; there is no mailmerge setting to do this for you. Such a macro might be coded along the lines of:


Code:
Sub Demo()
Application.ScreenUpdating = False
Dim iShp As InlineShape
For Each iShp In ActiveDocument.InlineShapes
  With iShp
    .LockAspectRatio = True
    If .Range.Information(wdWithInTable) = True Then
      If .Range.Cells(1).PreferredWidthType = wdPreferredWidthPoints Then
        .Width = .Range.Cells(1).Width
        If .Range.Cells(1).HeightRule = wdRowHeightExactly Then
          If .Height > .Range.Cells(1).Height Then
            .Height = .Range.Cells(1).Height
          End If
        End If
      End If
    End If
  End With
Next
Application.ScreenUpdating = True
End Sub
and would be run on the mailmerge output document.

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm
For Mac macro installation & usage instructions, see: https://wordmvp.com/Mac/InstallMacro.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change multiple pictures in Word 2016 to all new pictures that appear in a specified order? chaz Word VBA 7 07-11-2018 03:57 AM
Pictures! Comment pictures ? lukael Word 4 07-11-2015 04:04 AM
Pictures! Pictures in Word OfficeBuddy102 Drawing and Graphics 1 05-12-2011 12:49 PM
Pictures! adding Pictures Maureenbool PowerPoint 1 08-24-2010 02:46 PM
Pictures! jumping pictures jvandyke Drawing and Graphics 6 04-28-2010 09:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:31 PM.


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