Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
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
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

Attached Images
File Type: jpg MailMerge_Error.jpg (33.0 KB, 10 views)
Reply With Quote
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
Join Date: Aug 2014
Posts: 3,348
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all

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
Reply With Quote

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 - Senior Forums

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

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