In the Master Data Services Add-in for Excel, email a shortcut query file to someone when you want to ensure they’re working with the same data that you are. You should share queries rather than saving the worksheet and emailing it.
To perform this procedure:
You must have Outlook 2010 or later installed.
You must have MDS-managed data in an active worksheet in Excel.
To send a shortcut query file
Ensure that the data in the worksheet is in the format you want to share. For more information about filtering data and reordering columns, see Filter Data before Exporting (MDS Add-in for Excel) and Reorder Columns (MDS Add-in for Excel).
In the Save and Send group, click Send Query. An email message opens and the shortcut query file is attached.
- To open the shortcut query file, the recipient of the email must have the MDS Add-in for Excel installed. The recipient can double-click the file to open it.