Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-21-2019, 04:32 PM
Delroy Delroy is offline Mail Merge-Rookie--Needs Help Windows 7 64bit Mail Merge-Rookie--Needs Help Office 2007
Novice
Mail Merge-Rookie--Needs Help
 
Join Date: Oct 2019
Posts: 1
Delroy is on a distinguished road
Unhappy Mail Merge-Rookie--Needs Help

Hello, beautiful people, please help me with this Mail Merge issue.


I am trying to do a one to many Mail Merge with data from excel into word and whenever the name has one than one record the Name field gets duplicated (see image attached) the name repeat the same amount time as the record for this client.

i.e.-- Hello Allison[~]Allison[~]Allison[~]Allison[~]Allison
1061252 Single-Family
1061253 Single-Family
1062489 Single-Family
1057577 Single-Family
1062439 Single-Family


thanks
Del
Attached Images
File Type: jpg MailMerge_Error.jpg (33.0 KB, 14 views)
Reply With Quote
  #2  
Old 10-21-2019, 11:35 PM
gmayor's Avatar
gmayor gmayor is offline Mail Merge-Rookie--Needs Help Windows 10 Mail Merge-Rookie--Needs Help Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

This looks like you may be using my Many to One mail merge add-in - Merge Many To One . The issue shown arises because you have declared the name field, which contains 'Allison' here, as a child field. Only the fields in the table are child fields.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
field get duplicated, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
Mail Merge-Rookie--Needs Help How do I mail merge records into table columns with more than one merge field? tech123 Mail Merge 1 04-26-2017 07:13 PM
Rookie Question about Onenote for Mac & Xfer from Evernote fbx OneNote 0 08-18-2016 10:29 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Rookie question: auto-copying fields reviewboy Word 1 12-04-2009 11:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:07 AM.


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