Microsoft Office Forums Mail Merge - Cannot Locate Source Data

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2018, 10:55 AM
Karen615 Karen615 is offline Mail Merge - Cannot Locate Source Data Windows 7 64bit Mail Merge - Cannot Locate Source Data Office 2010 64bit
Advanced Beginner
Mail Merge - Cannot Locate Source Data
 
Join Date: Jun 2011
Location: Chicago
Posts: 40
Karen615 is on a distinguished road
Default Mail Merge - Cannot Locate Source Data

Using MS 2016




I have a letter in Word format and a source spreadsheet on my computer. I created a mail merge into the letter based on the spreadsheet data. Now I have 20 letters with the populated data from the spreadsheet. So far so good! I emailed the letters to someone and he couldn't open the letters. He received a message "Could not locate source data." How can this be rectified? I know that I can convert to PDF, but he wants the merged letters so he can make specific changes to a few letters.


You help is greatly appreciated.
Reply With Quote
  #2  
Old 08-03-2018, 12:24 PM
Charles Kenyon Charles Kenyon is offline Mail Merge - Cannot Locate Source Data Windows 10 Mail Merge - Cannot Locate Source Data Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,056
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

You need to complete the merge.
What he received was a primary merge document rather than a completed merge.


Yes, you can save or print this as pdf.
Reply With Quote
  #3  
Old 08-03-2018, 05:40 PM
macropod's Avatar
macropod macropod is offline Mail Merge - Cannot Locate Source Data Windows 7 64bit Mail Merge - Cannot Locate Source Data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,577
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by Karen615 View Post
Now I have 20 letters with the populated data from the spreadsheet. So far so good! I emailed the letters to someone and he couldn't open the letters. He received a message "Could not locate source data."
That suggests you've actually made 20 copies of the mailmerge main document, each with a different record previewed. What you need to do is open the mailmerge main document then go to Mailings|Finish & Merge>Edit Individual Documents>All>OK. That will generate an output document with all your records. Save and send that document.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge using HTML Data Source chadnewman Mail Merge 0 09-21-2017 07:14 AM
Mail Merge - Cannot Locate Source Data Migrating Mail Merge Data Source jameswang Mail Merge 2 06-07-2015 03:03 AM
Mail Merge - Cannot Locate Source Data Enable Mail Merge Data Source always in same folder alleycat1998 Mail Merge 1 04-10-2013 03:02 AM
define a mail merge data source using unc (universal naming convention) charlesandrews Mail Merge 0 08-21-2012 10:33 AM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM


All times are GMT -7. The time now is 05:37 AM.


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