#1
|
|||
|
|||
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, |
#2
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 - Create seperate Mail merge pdf for each sheets of an excel file | sureshbvs | Word VBA | 1 | 03-12-2021 05:42 AM |
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 |
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 |