Save Merged Files to a Specific Google Drive Folder
How to change the default save location for merged files to a folder of my choice on Google Drive?
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.
From Google Docs
Step 1: Cick Options
In Google Docs, click on Options in the Mail Merge sidebar to open the Options dialog box.
Step 2: Click My Drive
Click on My Drive under Save Merged Files To.
Step 3: Select Google Drive folder
Select a Google Drive folder in which to save your merged files (e.g., My Merge Files), and then click on Select.
Step 4: Click Save
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.
Step 5: Select Letters & click Merge
Select Letters from the Merge To list and then click on Merge.
Step 6: View files on Google Drive
Click the link provided to view your files on Google Drive.
From Google Slides
Step 1: Click Options
In Google Slides, click on Options in the Mail Merge sidebar to open the Options dialog box.
Step 2: Click My Drive
Click on My Drive under Save Merged Files To.
Step 3: Select Google Drive folder
Select a Google Drive folder in which to save your merged files (e.g., My Merge Files), and then click on Select.
Step 4: Click Save
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.
Step 5: Select Presentations & click Merge
Select Presentations from the Merge To list, and then click on Merge.
Step 6: View files on Google Drive
Click the link provided to view your files on Google Drive.
From Google Sheets
Step 1: Click 'My Drive'
In Google Sheets, click the default location My Drive to open the Google Drive Folder dialog box.
Step 2: Choose a Google Drive folder
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.