Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Go Back  Xtreme Visual Basic Talk > > > Complex VBA Code to Resize Alternating Images at the End of a Mail Merge


Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2017, 04:20 PM
macropodjr macropodjr is offline
Newcomer
 
Join Date: Sep 2017
Location: Southern California
Posts: 2
Default Complex VBA Code to Resize Alternating Images at the End of a Mail Merge


Hello!

I have been working on this project for work for a couple weeks now and cannot figure out how to write the macro according to the needs of the project. I am using mail merge to create a three different letters with the use of many If-Then-Else statements. There are links to two different images within each letter. The first image is a header that is formatted as the correct size. The second image is stretched to the wrong size and, when the image is toggled, the image is no longer stretched but it is still not the right size.

I have tried placing the image merge field in a text box that was the correct size but the image did not fit the box. I have tried to program a macro to resize the selected images but am unable to select every other image in the document. There are nearly 1,000 letters and if I am unable to figure this out I will have to resize every image manually.

I have searched far and wide for the answer but have come up empty handed. One thought I had was to program a macro that would resize every other image in a document to a certain height or width, while keeping the aspect ratio. If someone could help me write a macro for this that would be tremendous!!

I have attached an image of the mail merge document I am working with, the document it produces, and the ideal look of the document for clarity. The first name of the student has been blacked out for privacy purposes.

Sincerely,
macropodjr
Attached Images
File Type: png image1.png (101.9 KB, 3 views)
File Type: png image2.png (144.2 KB, 2 views)
File Type: png image3-2.png (153.2 KB, 1 views)
Reply With Quote
  #2  
Old 09-11-2017, 11:56 AM
macropodjr macropodjr is offline
Newcomer
 
Join Date: Sep 2017
Location: Southern California
Posts: 2
Default Ignore this thread

I apologize but it seems that I was unaware to the proper Forum etiquette and have posted this question too many times on other forums. If you have an answer or solution to my dilemma please view the original at the following link: Page Not Found - Microsoft Office Forums - Powered by vBulletin

Sorry again and please have grace towards me. I am a novice in the world of forums.

Thank you kindly,
macropodjr
Reply With Quote
Reply

Tags
image, document, size, resize, macro, merge, mail, images, letters, unable, project, stretched, figure, box, correct, write, program, manually, answer, searched, wide, handed, empty, 1, 000, clarity


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
 
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
Complex VBA Code to Resize Alternating Images at the End of a Mail Merge
 
-->