![]() |
|
![]() |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
I made a label customization in Word with 8 boxes on one page.
Then the data source from Excel has 16 rows with one of the image columns. I followed the tutorial to display images using Text Box but when I Preview Result only row 8 appears on 8 label boxes on one page. |
#2
|
||||
|
||||
![]()
Which mailmerge record did you tell Word to preview?
Is your mailmerge configured as a label mailmerge? Do you have a NextRecord field in each cell after the first? Have you actually tried completing the mailmerge? None of this is apparent from your post or your images. Also, kindly attach your images directly to your post. Do not simply provide links to 3rd-party sites.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
![]()
Cross-posted at: MS Answers
For cross-posting etiquette, please read: A message to forum cross posters - Excelguru
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
![]()
This is Mail Merge that I tell you Word to preview:
As in the image above, why when I do ABC Preview Results, they all copy the same link even though in my Excel data each data is different. See my Excel data below: But if I put Insert Merge Field outside the Text Box they automatically sort in order. The links for the images should be different according to the order. Why are the links for these images all the same and they all start from row 8 for number 8? |
#5
|
||||
|
||||
![]()
You haven't answered all the questions I asked.
What is more, why are you even trying to use textboxes inside the labels?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
![]()
Sorry if you don't understand what I want, I've tried to explain the problem I'm having. The goal is how do I display an image on a Label that I've created using Mail Merge Field?
|
#7
|
||||
|
||||
![]()
Well, if you're not going to answer the questions you've been asked, I have better things to do with my time.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#8
|
|||
|
|||
![]()
Which mailmerge record did you tell Word to preview?
I want to preview the mailmerge record "Gambar". Is your mailmerge configured as a label mailmerge? Yes that's right, I configured it as a Mailmerge Label. Do you have a NextRecord field in each cell after the first? Yes, that's right. Because I will print all the data in Excel. Have you actually tried completing the mailmerge? Yes, I have completed it. None of this is apparent from your post or your images. I have tried to explain and show the pictures according to your question. Also, kindly attach your images directly to your post. Do not simply provide links to 3rd-party sites. Sorry because this is my first time posting on this website. |
#9
|
||||
|
||||
![]()
And when you completed the mailmerge, what output did it produce in the output document?
You also haven't answered my question as to why you're inserting a textbox into the table cell used for the mailmerge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#10
|
|||
|
|||
![]()
The output produced in Mailmerge is an image in a Textbox, but the image is all the same, whereas the image should display a different image according to the row in Excel.
Because I followed the tutorial on YouTube, and because if I don't put it in the Textbox, I can't adjust the exact image size. |
#11
|
||||
|
||||
![]()
The correct way to do that is to use labels of the required size. Alternatively, if you really need the larger labels, insert a nested table with the appropriate fixed row height, column width, and vertical/horizontal positioning.
See attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#12
|
|||
|
|||
![]()
Thank you so much, you saved me. This works with a table.
|
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jen75 | Word VBA | 6 | 10-02-2022 11:57 AM |
![]() |
Cherish | Mail Merge | 1 | 04-01-2020 01:28 AM |
![]() |
Karen615 | Mail Merge | 2 | 08-03-2018 05:40 PM |
![]() |
jameswang | Mail Merge | 2 | 06-07-2015 03:03 AM |
Merge fields in Word and source data from Excel | SteveVai | Mail Merge | 3 | 03-13-2014 05:25 AM |