Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2022, 02:54 PM
LisaG LisaG is offline Mail merge picking up data from wrong row Windows 10 Mail merge picking up data from wrong row Office 2010
Novice
Mail merge picking up data from wrong row
 
Join Date: Jan 2022
Posts: 1
LisaG is on a distinguished road
Angry Mail merge picking up data from wrong row

Hello!

I hope somebody can please help?



I have a data source file of address/company names, etc, using Excel which I've pulled through into Word for a mail merge. My question is if I only have one field called 'Company file' and only one field called 'Address', why would the address in Word match the first row I have on my data source file in Excel but when I use the Company file field, it's picking up the company on the second row of my data file in Excel. It's basically mixing the information up between one row and the next.

Is this even possible? If so, what would I have had to do wrong?

Thanks,

Lisa.
Reply With Quote
  #2  
Old 01-25-2022, 06:52 AM
kilroyscarnival kilroyscarnival is offline Mail merge picking up data from wrong row Windows 10 Mail merge picking up data from wrong row Office 2019
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

It's difficult to tell without seeing it. Are you merging to letters, or something where there's more than one (label, table, etc.) per page?

Look for a stray <<Next Record>> in your Word template. And, of course, check your Excel source for any stray information, including hidden rows or columns.

Also be aware that when you do a preview of results, things don't always look right. For example, if I'm doing a merge to two tables per page, it usually shows me 1 and 2 on the first page, 2 and 3 on the second, etc. in preview mode only. When I do the actual merge things generally look right.

Ann
Reply With Quote
Reply

Tags
data source, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge picking up data from wrong row 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
Can I mail merge data on front side (page 1) and static data (page 2) back of business cards? dhouston1000 Publisher 0 01-24-2020 04:34 PM
Is data merge and mail merge the same thing? ikearns Mail Merge 1 09-12-2014 03:53 AM
Mail merge picking up data from wrong row Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? brunofirst Mail Merge 7 02-27-2014 02:30 PM
Mail merge picking up data from wrong row Mail merge going from the wrong account alexb123 Mail Merge 3 11-15-2011 11:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:33 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