Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-14-2024, 08:41 PM
itgmart itgmart is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2021
Novice
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source?
 
Join Date: Oct 2024
Posts: 7
itgmart is on a distinguished road
Question Why does Mail Merge in Word with Text Box only display row 8 from Excel data source?

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.
Reply With Quote
  #2  
Old 10-14-2024, 08:58 PM
macropod's Avatar
macropod macropod is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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

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]
Reply With Quote
  #3  
Old 10-14-2024, 09:01 PM
macropod's Avatar
macropod macropod is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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

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]
Reply With Quote
  #4  
Old 10-17-2024, 02:13 AM
itgmart itgmart is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2021
Novice
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source?
 
Join Date: Oct 2024
Posts: 7
itgmart is on a distinguished road
Default

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?
Attached Images
File Type: png Capture1.PNG (61.8 KB, 13 views)
File Type: png Capture2.PNG (137.7 KB, 12 views)
File Type: png Capture0.PNG (57.7 KB, 12 views)
File Type: png Capture3.PNG (59.3 KB, 13 views)
File Type: png Capture4.PNG (68.6 KB, 12 views)
Reply With Quote
  #5  
Old 10-17-2024, 04:23 AM
macropod's Avatar
macropod macropod is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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

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]
Reply With Quote
  #6  
Old 10-17-2024, 06:42 PM
itgmart itgmart is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2021
Novice
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source?
 
Join Date: Oct 2024
Posts: 7
itgmart is on a distinguished road
Default

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?
Reply With Quote
  #7  
Old 10-17-2024, 06:48 PM
macropod's Avatar
macropod macropod is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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

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]
Reply With Quote
  #8  
Old 10-17-2024, 07:40 PM
itgmart itgmart is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2021
Novice
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source?
 
Join Date: Oct 2024
Posts: 7
itgmart is on a distinguished road
Default

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.
Reply With Quote
  #9  
Old 10-17-2024, 07:41 PM
macropod's Avatar
macropod macropod is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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

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]
Reply With Quote
  #10  
Old 10-17-2024, 07:54 PM
itgmart itgmart is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2021
Novice
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source?
 
Join Date: Oct 2024
Posts: 7
itgmart is on a distinguished road
Default

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.
Reply With Quote
  #11  
Old 10-17-2024, 07:58 PM
macropod's Avatar
macropod macropod is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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 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.
Attached Files
File Type: docx NestedTableLabelMergeDemo.docx (12.8 KB, 2 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #12  
Old 10-20-2024, 07:01 PM
itgmart itgmart is offline Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Windows 10 Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Office 2021
Novice
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source?
 
Join Date: Oct 2024
Posts: 7
itgmart is on a distinguished road
Default

Thank you so much, you saved me. This works with a table.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Feeding a Word Document from Excel Source (not a mail merge) Jen75 Word VBA 6 10-02-2022 11:57 AM
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Mail merge from 2 different data source Cherish Mail Merge 1 04-01-2020 01:28 AM
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Mail Merge - Cannot Locate Source Data Karen615 Mail Merge 2 08-03-2018 05:40 PM
Why does Mail Merge in Word with Text Box only display row 8 from Excel data source? Migrating Mail Merge Data Source 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:59 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