cinetuta.blogg.se - Merge google drive folders

If you need to send the same Drive file to other recipients in the sheet, you can simply copy-paste the Drive link in the corresponding File Attachment cells of those rows. Switch to the Google Sheet and paste the link under the File attachments column for the recipient who should receiving this particular file. Click the Copy Link button on the next screen to copy the shareable link of that file in your clipboard. To attach a file from Google Drive, right-click the file inside Google Drive and choose the Get Link option. The Mail Merge app will fetch the corresponding files for each of these links from your Google Drive and attach them to the outgoing email. This column contains links to your files in Google Drive and you can also add multiple links separated by commas. Your Mail Merge sheet has a special File Attachments column that is used to determine which attachments should be sent to the email address specified in that row. This approach is recommended if have files that should be sent to all recipients of the campaign. If you are using a Gmail draft as an email template for merge, attach the common files to your draft message itself.Īny files that are attached to the draft message are automatically sent to all recipients of mail merge. Thus, both files brochure.pdf and invoice-A.xlsx are sent to recipient A.

You may also have files like invoice-A.xlsx and invoice-B.xlsx that should be sent to recipients in row #1 and row #2 of the spreadsheet respectively.

Send unique attachments for each recipient and also attach files that are common to each recipient.įor instance, you may have a common file called brochure.pdf in your Google Drive that should be sent to every recipient of the Mail Merge campaign.

Send different file attachments to different recipients.

Send the same file attachment to all recipients.

With Mail Merge for Gmail, you can add one or more file attachments to your emails.