Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-07-2021, 08:22 AM
Huey Huey is offline Mail Merge - Infinite Copies Windows 10 Mail Merge - Infinite Copies Office 2016
Novice
Mail Merge - Infinite Copies
 
Join Date: Oct 2021
Posts: 1
Huey is on a distinguished road
Default Mail Merge - Infinite Copies

Experiencing issues with performing a Mail Merge in Word. I've got a data source file consists of 48 contacts that are pulled from Excel.



When opening up the mail merge and importing from Excel, Word copies what appears to be hundreds of other extra copies.

In addition to that, one field that is included fromt he original template is not transferred over to the other copies. I have to copy and paste from the original one to the others.

Anyone ever run into this issue? Please let me know what information you need in order to assist.

Much appreciated,
Reply With Quote
  #2  
Old 10-14-2021, 03:03 PM
Guessed's Avatar
Guessed Guessed is offline Mail Merge - Infinite Copies Windows 10 Mail Merge - Infinite Copies Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If you are getting additional unexpected rows from the source data in Excel then you need to look at how the source range is defined. Excel often has a 'used range' for a spreadsheet but it may also have a defined 'table' (aka List Object). It is likely that these areas are acting as the source range.

The easiest fix would be to select the rows immediately under the data in Excel and delete those rows. This will effectively collapse the range that is serving as the source for your mail merge. Note that if you have hundreds of extra records then you will need to delete hundreds of extra rows in the source worksheet.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Infinite Copies Is there a way to do a mail merge type of addition of data after a mail merge has been done? mtandino Word 4 06-01-2021 02:00 PM
Mail Merge - Infinite Copies Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file sureshbvs Word VBA 1 03-12-2021 05:42 AM
Mail Merge - Infinite Copies Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge djrexy Mail Merge 1 05-20-2020 04:04 PM
Mail Merge - Infinite Copies Infinite Loop when Finding Styles B4rikuda Word VBA 3 11-21-2018 04:27 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 PM.


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