OneDrive MailMerge

[T_Lister]

We have recently migrated all of our Home drive files from our file servers into OneDrive and have in turn mapped our Home drives to our OneDrive folders. This has worked a treat. However, MailMerge... When we try to import a list from an Excel file within our Home Drive (OneDrive) we get the attached error.

 

Has anyone experienced this, is their a work around, or is it an issue with Office 365?

 

 

 

Thanks in advance,

Trenton

Edited November 9, 2020 by Trenton_Lister

[denzal2k4]

This is the ridiculous "fix" we found for this, it does work but is a massive PITA

 

1. Set up a mail merge in the Word document with a local file.

 

2. Change the Word document extension to .zip from .doc or .docx

 

3. Extract the zip file into a new folder.

 

4. Open the word\settings.xml file or word\settings\settings.xml file in notepad

 

5. In notepad, change the merge file source location and name information in both (two) places with the url of the sharepoint source file, and save (example: target=‘file:///c/documents/myfile.xlsx’ to target=‘https://sharepoint/folder/filename.xlsx’)

 

6. Repeat 4,5 for the file rels\setttings.xml.rels

 

7. Rezip the extracted folder and change the extension back to .doc or .docx OR

 

7b. replace the files in the zipped folder and change the extension back to .doc or .docx

 

8. Your word document is now successfully mailmerged with a sharepoint source file. And it works perfectly.

 

Source: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_other-mso_2016/change-microsoft-word-document-mail-merge-source/25568896-3fff-4421-b056-684a9dcd125c

[T_Lister]

And I'm guessing that's a document by document fix? I confess that has made me chuckle.

 

I suspect it's going to be easier to just have them move their excel sheet to a local share when they need to merge if it's not an every day thing...

[denzal2k4]

Oh yeh of course its document by document, thanks Microsoft!