By default, files are saved on My Drive. This article describes how to save your merged files in a specific folder on Google Drive, enabling better organization of merged files produced from different Google Docs, Slides and Sheets templates. Merged files may include letters generated during mail merges, and files sent as PDF email attachments based on Google Docs templates.
In Google Docs, click on Options in the Mail Merge sidebar to open the Options dialog box.
Click on My Drive under Save Merged Files To.
Select a Google Drive folder in which to save your merged files (e.g., My Merge Files), and then click on Select.
Click on Save to apply the changes.
Note that My Drive under Save Merged Files To in the Options dialog box changes to your preferred save location (e.g., My Merge Files).
You also have the option to save your merged documents as PDF files by selecting Yes from the Save to PDF drop-down menu.
Select Letters from the Merge To list and then click on Merge.
Click the link provided to view your files on Google Drive.
In Google Slides, click on Options in the Mail Merge sidebar to open the Options dialog box.
Click on My Drive under Save Merged Files To.
Select a Google Drive folder in which to save your merged files (e.g., My Merge Files), and then click on Select.
Click on Save to apply the changes.
Note that My Drive under Save Merged Files To in the Options dialog box changes to your preferred save location (e.g., My Merge Files).
You also have the option to save your merged documents as PDF files by selecting Yes from the Save to PDF drop-down menu.
Select Presentations from the Merge To list, and then click on Merge.
Click the link provided to view your files on Google Drive.
In Google Sheets, click the default location My Drive to open the Google Drive Folder dialog box.
Choose a folder from your Google Drive or Shared Drives and click Select. The name of the folder will appear in the main dialog box. Click the Save button to save changes.