locked
Mail Merge Issue Sharing Excel As Data Source Office 2013 RRS feed

  • Question

  • We have Excel files that are generated via the following commands on a schedule:

    The command that creates the .xls files is:

            DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, dbfFiles(counter), _

                            baseFilepath & dbfFiles(counter) & fileExtension, True

    The command that creates the .xlsx files is:

            DoCmd.TransferSpreadsheet acExport, , dbfFiles(counter), _

                            baseFilepath & dbfFiles(counter) & fileExtension, True

     

    Counter is an array that contains the names of the files, fileExtension is set to .xls or .xlsx.

    These .xlsx files are placed on a shared drive.

    Users have trouble with mail merges in Word 2013 when linked to .xlsx and .docx files. If any user is in the file, or using a mail merge, no one else can access the Excel file for merging.  If one user is already in the .xlsx file and a second tries to come in and use the file simultaneously, an error is displayed.

    Error has occurred: Exernal table is not in the expected format.

    Items already verified:

    1. The datasource .xlsx file is accessilble by two people as a shared document.

    2. Have tried opening the excel document prior to merging.  Same error.

    3. Permissions on the share drive are the good.  Same permissions worked with Office 2010.

    Friday, October 10, 2014 12:49 PM

All replies