#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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 [Fmr MS MVP - Word] |
|
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 |
Migrating Mail Merge Data Source | jameswang | Mail Merge | 2 | 06-07-2015 03:03 AM |
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 |