Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-22-2025, 11:28 AM
Carlos153 Carlos153 is offline Only takes first code in the list Windows 11 Only takes first code in the list Office 2019
Novice
Only takes first code in the list
 
Join Date: Mar 2025
Posts: 4
Carlos153 is on a distinguished road
Default Only takes first code in the list

Hello all,

I posted this similar question in an excel forum but I think it may be more of a word question.
I am trying to use an excel sheet to merge several different barcodes onto an existing word document. I seem to get the merge correct but it only takes the first barcode number and repeats it. Do I need to format the excel sheet specially so it will see all the barcodes. (the barcodes are in a table) Any pointers would be greatly appreciated.


Thanks
Reply With Quote
  #2  
Old 03-22-2025, 03:38 PM
Charles Kenyon Charles Kenyon is offline Only takes first code in the list Windows 11 Only takes first code in the list Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,533
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Each record for mailmerge is a separate row.
Mail merge using an Excel spreadsheet - Word .
Please also provide a link to your cross-post here.
For cross-posting etiquette, please read: A Message to Forum Cross-Posters
Reply With Quote
  #3  
Old 03-23-2025, 11:57 AM
Carlos153 Carlos153 is offline Only takes first code in the list Windows 11 Only takes first code in the list Office 2019
Novice
Only takes first code in the list
 
Join Date: Mar 2025
Posts: 4
Carlos153 is on a distinguished road
Default

Thank you for the info.
Here is the link to the crosspost: Sort of excel? Mailmerge (word) not working using excel sheet. | MrExcel Message Board
Reply With Quote
  #4  
Old 03-23-2025, 04:38 PM
macropod's Avatar
macropod macropod is offline Only takes first code in the list Windows 10 Only takes first code in the list Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Kindly attach a sample Word document and Excel worksheet so we can see what you're working with. Depending on the structure of your data source, you may need to use a label merge, directory merge, or even just a plain letter merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 03-23-2025, 10:28 PM
Carlos153 Carlos153 is offline Only takes first code in the list Windows 11 Only takes first code in the list Office 2019
Novice
Only takes first code in the list
 
Join Date: Mar 2025
Posts: 4
Carlos153 is on a distinguished road
Default

I will try to do that when I get home. I think I should be using the mergebarcode command.
Reply With Quote
  #6  
Old 03-27-2025, 12:08 PM
Carlos153 Carlos153 is offline Only takes first code in the list Windows 11 Only takes first code in the list Office 2019
Novice
Only takes first code in the list
 
Join Date: Mar 2025
Posts: 4
Carlos153 is on a distinguished road
Default

I figured it out! There is a next record command that wasn't there. I put that in and it worked. Thank you all.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiselection drop down list - looking for Add-In rather than code Redmeat Word 7 02-27-2024 12:09 PM
Only takes first code in the list List of ascii code of Character Symbols or code for all symbols used in Word SamDsouza Word VBA 3 03-12-2020 04:49 AM
Drop Down List that takes you to specific slides sep324 PowerPoint 1 07-11-2014 11:03 PM
bar code list msheyworth Excel 2 08-26-2012 01:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:29 AM.


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