Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2022, 12:47 PM
Denise Denise is offline Inserting images into mailmerge labels Windows 10 Inserting images into mailmerge labels Office 2013
Novice
Inserting images into mailmerge labels
 
Join Date: Mar 2022
Posts: 4
Denise is on a distinguished road
Default Inserting images into mailmerge labels

I am hoping this is still monitored. After many, many days of trying to figure this out I found your code. Thank you. I haven't programmed in 15+ years, so I never could've written it myself.
However, I do have a problem I noticed was touched on before, but not for the same exact program and sitz I am in.

Using Word 2013. Labels merge. Everything seems to work just fine. Then the document actually doubles each image. ie: 1,1 2,2 3,3...etc.
What can I do about this?


Thanks so much!!!

Last edited by macropod; 03-20-2022 at 02:37 PM. Reason: Split from https://www.msofficeforums.com/word-vba/16772-4-digital-images-1-page.html
Reply With Quote
  #2  
Old 03-19-2022, 02:32 PM
macropod's Avatar
macropod macropod is offline Inserting images into mailmerge labels Windows 10 Inserting images into mailmerge labels Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

So why are you not inserting the images during the merge itself? See, for example, the Managing Mailmerge Graphics topic on the Mailmerge Tips and Tricks page at:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-20-2022, 11:42 AM
Denise Denise is offline Inserting images into mailmerge labels Windows 10 Inserting images into mailmerge labels Office 2013
Novice
Inserting images into mailmerge labels
 
Join Date: Mar 2022
Posts: 4
Denise is on a distinguished road
Default VBA Word/Merge

I'd love it to be that simple. Mail merge doesn't let you insert the pics at once for labels. It will replicate the same label and you can choose to type each individually, but when you have over 2,000+ images, well...that's not feasible. Then again, maybe I just don't remember now.
Your code is exactly what I needed. But, I don't want a caption or extra row inserted. I was able to edit it to the extent of removing the caption, but not the extra row. I've edited and re-edited, but I'm either missing one thing or another with each edit. I really don't remember all the syntax for too many years ago, though I used to write code in my sleep...today, Lyme Disease has taken much of my ability to analyze anymore. So, mistakes are something I repeat daily...lol. I just need to get this down though. I'm trying to finish up inventory on my parents estate probate and using bar codes is the most effective way to do this. Can you assist with this problem?
Thanks so much for your time!
Reply With Quote
  #4  
Old 03-20-2022, 02:39 PM
macropod's Avatar
macropod macropod is offline Inserting images into mailmerge labels Windows 10 Inserting images into mailmerge labels Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Quote:
Originally Posted by Denise View Post
I'd love it to be that simple. Mail merge doesn't let you insert the pics at once for labels. It will replicate the same label and you can choose to type each individually, but when you have over 2,000+ images, well...that's not feasible.
On the contrary, the field code displayed in the link I posted I generate a separate image in every label - provided the image names are in the mailmerge data source.

The problem with using a post-merge macro to do this is that the pictures may not be inserted in the required order.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Font size change after mailmerge (labels) Ludo_S Mail Merge 3 05-02-2016 02:34 PM
Inserting images into mailmerge labels mailmerge labels problem word 2013 Haymoon Mail Merge 4 10-08-2014 07:50 AM
Directory MailMerge with Category Grouped Lists on Labels screech Mail Merge 3 06-18-2014 11:41 PM
Inserting images into mailmerge labels SQL MailMerge Labels Mark J Rees Mail Merge 2 05-10-2013 06:00 PM
MailMerge Labels Question trims30 Mail Merge 0 08-04-2010 05:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:45 PM.


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