{"id":12374,"date":"2020-05-26T00:11:34","date_gmt":"2020-05-26T00:11:34","guid":{"rendered":"https:\/\/www.gmass.co\/blog\/?p=12374"},"modified":"2024-10-22T17:32:25","modified_gmt":"2024-10-22T17:32:25","slug":"mass-email-with-personalized-attachments","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/","title":{"rendered":"How to send multiple emails with different attachments in Gmail"},"content":{"rendered":"<p>Have you ever wondered how to send multiple emails with different attachments in Gmail?<\/p>\n<p>Well, you can now easily send a mass email or <a href=\"https:\/\/www.gmass.co\/gmail-mail-merge\">mail merge in Gmail<\/a> with <strong>personalized attachment files<\/strong>.<\/p>\n<p>Why would you ever need to do this? Let&#8217;s say you run a small business that needs to <strong>send PDF invoices to your customers<\/strong> once a month. Your billing software generates the PDF invoices, one for each of your 100 customers. Now you need to <strong>send the right invoice to the right customer<\/strong>. Until now, you&#8217;d have to prepare multiple emails manually \u2014 composing and sending 100 individual emails, and having to attach the right PDF to each email.<\/p>\n<p>But now, you can <strong>automate<\/strong> all of this. Here&#8217;s a two-minute video demo:<\/p>\n<div style=\"margin-bottom: 10px; position: relative; padding-bottom: 56.25%;\"><iframe style=\"position: absolute; top: 0; left: 0; width: 100%; height: 100%;\" src=\"https:\/\/www.youtube.com\/embed\/3xEB2nqNQsI\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/div>\n<h2>What tools will you need to mail merge with individual attachments?<\/h2>\n<ol>\n<li>All of your <strong>attachment files<\/strong>, ready to send<\/li>\n<li>A <strong>Google Sheet<\/strong> that lists the email addresses in one column and the file names in the other<\/li>\n<li>A place to <strong>host the files<\/strong>, such as Google Drive, Amazon S3, Dropbox, or your own web server<\/li>\n<li>A Gmail or Google Workspace account<\/li>\n<li><a href=\"https:\/\/chrome.google.com\/webstore\/detail\/gmass-powerful-mail-merge\/ehomdgjhgmbidokdgicgmdiedadncbgf?hl=en-US\">GMass<\/a> installed and connected<\/li>\n<\/ol>\n<h2>Host your attachments somewhere<\/h2>\n<p>Your files can either be in your <strong>Google Drive<\/strong> or somewhere publicly accessible on the web, like your own web server, a public <strong>Dropbox<\/strong> folder, or a public <strong>AWS S3 bucket<\/strong>.<\/p>\n<p>If you&#8217;re going to host your file attachments in your Google Drive, our software needs permission to access your Google Drive. It&#8217;s <strong>the one step you have to take in advance<\/strong> of sending any personalized attachments with your bulk emails.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>You must give GMass read-only permissions to your Google Drive! <\/strong><\/span><span style=\"color: #ff0000;\">By default, GMass doesn&#8217;t have permissions for this when you sign up for an account.<\/span><\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>To <strong>allow GMass to download different attachment files<\/strong> from your Google Drive:<\/p>\n<p><strong><span style=\"color: #ff0000;\"> &gt;&gt;&gt;&gt;&gt;&gt;&gt;<\/span><\/strong> <a href=\"https:\/\/www.gmass.co\/oauth\/login?scopes=drive\" target=\"_blank\" rel=\"noopener noreferrer\">FOLLOW THIS LINK<\/a> <strong><span style=\"color: #ff0000;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;<\/span><\/strong><\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>and log in with the <strong>same account<\/strong> that you&#8217;re using to send your mass email.<\/p>\n<p>Also, note that the files don&#8217;t all have to be in the same folder; they can be spread across multiple folders as long as they&#8217;re in one single Google Drive account. Lastly, if you use Google Drive, be sure that the &#8220;Convert uploaded files&#8230;&#8221; setting is UNCHECKED:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12780\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb.png\" alt=\"UNCHECK convert uploaded files\" width=\"731\" height=\"449\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb.png 1224w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb-300x184.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb-768x472.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb-1024x629.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb-36x22.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/013-uncheck-convert-files-95kb-48x29.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><br \/>\n(Click the Settings gear first at the top-right, then uncheck that box, then click DONE.)<\/p>\n<p>If you don&#8217;t uncheck this box, then certain file types, like .txt files, won&#8217;t remain as txt files after you upload them; they&#8217;ll get converted to Google Docs and won&#8217;t be &#8220;attachable&#8221; to your personalized emails.<\/p>\n<h2>Set up your Google Sheet<\/h2>\n<p>First, set up your <strong>Google Sheet<\/strong>. Make sure your <strong>column headings<\/strong> are in the first row, and <strong>at a minimum you&#8217;ll need two columns<\/strong>, one for the <strong>email address<\/strong>, and one for the <strong>file to be attached<\/strong>. You can have other columns too, like <strong>FirstName<\/strong>, <strong>LastName<\/strong>, <strong>Company<\/strong>, and anything else you want to use to personalize your mail merge. Here&#8217;s what your spreadsheet should look like:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/001-personalized-attachment-spreadsheet-175kb.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12424\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/001-personalized-attachment-spreadsheet-175kb.png\" alt=\"personalized attachment spreadsheet\" width=\"730\" height=\"779\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/001-personalized-attachment-spreadsheet-175kb.png 1148w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/001-personalized-attachment-spreadsheet-175kb-281x300.png 281w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/001-personalized-attachment-spreadsheet-175kb-768x819.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/001-personalized-attachment-spreadsheet-175kb-960x1024.png 960w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/001-personalized-attachment-spreadsheet-175kb-34x36.png 34w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/001-personalized-attachment-spreadsheet-175kb-45x48.png 45w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p>The column containing the files can be named anything as long as it starts with &#8220;attachment.&#8221; Any of the following are valid column names:<\/p>\n<ul>\n<li>Attachment<\/li>\n<li>Attachment1<\/li>\n<li>AttachmentFile<\/li>\n<li>attachment10<\/li>\n<\/ul>\n<p><em>It&#8217;s not case sensitive, either.<\/em> If your files are hosted in Google Drive, then the column should contain just the file attachment name. If your files are hosted somewhere on the web, then the column should contain the full URL to the file. Here&#8217;s what your spreadsheet might look like if you&#8217;re hosting your files on your own web server for a mailing to multiple recipients.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12425\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb.png\" alt=\"personalized attachment with link to server\" width=\"730\" height=\"470\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb.png 1224w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb-300x193.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb-768x494.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb-1024x659.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb-24x15.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb-36x23.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/002-personalized-attachment-with-link-to-server-145kb-48x31.png 48w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p>If you&#8217;re a spreadsheet wizard, feel free to use <strong>formulas<\/strong> for the attachment column as well. For example, if you&#8217;re sending monthly statements to your customers, and your billing software generates the monthly statements in the format of [CustomerNumber].pdf, and CustomerNumber is one of the column in your spreadsheet, you can set the attachment column to &#8220;=A1&#8221; + .pdf.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12426\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb.png\" alt=\"personalized attachment from spreadsheet formula\" width=\"731\" height=\"222\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb.png 1224w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb-300x91.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb-768x233.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb-1024x311.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb-24x7.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb-36x11.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/003-personalized-attachment-from-spreadsheet-formula-47kb-48x15.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><\/p>\n<p>Finally, if you have <strong>blank cells<\/strong> in an &#8220;attachment&#8221; column, then it&#8217;s assumed that <strong>those recipients don&#8217;t have corresponding files<\/strong>, and the emails will be sent without any file attachment.<\/p>\n<h2>Connect to your spreadsheet, compose, and send your messages<\/h2>\n<p>If you&#8217;ve performed a mail merge with GMass before, the next step should be familiar. Click the Sheets connector button, choose your spreadsheet and worksheet, hit the &#8220;Connect&#8221; button, and a <strong>Gmail Compose<\/strong> will open. Type your message, and hit the GMass button. You don&#8217;t need to attach any files to this message. GMass will automatically detect the column in your spreadsheet containing the files to be attached and attach them to the individual emails.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12427\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb.png\" alt=\"personalized attachment email\" width=\"730\" height=\"406\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb.png 1224w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb-300x167.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb-768x427.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb-1024x569.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb-24x13.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb-36x20.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/004-personalized-attachment-email-52kb-48x27.png 48w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p>The only reason you would attach a file directly to the Gmail Compose window is if you <em>also<\/em> want a separate attachment to go to <em>all<\/em> recipients. In that case, any files you attach to the Draft will be sent to all recipients, and additionally, any personalized attachments set in the spreadsheet will also be sent to separate emails.<\/p>\n<p>For example, let&#8217;s say you publish a PDF newsletter monthly that you also want to send to everyone along with their personalized invoices. Then, you would attach the PDF newsletter to the Gmail Compose window, and after clicking GMass, each of the bulk personalized emails would be sent the same newsletter PDF as one attachment and an individual personalized invoice PDF as a second attachment.<\/p>\n<h2>Need to send personalized emails with more than one attachment?<\/h2>\n<p>Do you need to send <strong>more than one personalized attachment<\/strong> per recipient? For example, if every month, you send your customers <strong>an invoice<\/strong> and an <strong>account summary<\/strong>, and they are <strong>two different PDFs<\/strong>, then you can have <strong>TWO columns<\/strong> in your spreadsheet, for example:<\/p>\n<ul>\n<li>Attachment1<\/li>\n<li>Attachment2<\/li>\n<\/ul>\n<p>GMass will notice this, and send both personalized files to each recipient.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments.png\" data-rel=\"lightbox-image-5\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12428\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments.png\" alt=\"multiple personalized attachments\" width=\"730\" height=\"432\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments.png 1224w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments-300x177.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments-768x454.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments-1024x606.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments-24x14.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments-36x21.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/005-multiple-personalized-attachments-48x28.png 48w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<h2>Automate this to send emails with attachments every day, week, or month<\/h2>\n<p>Do you typically send your customers multiple messages each month?<\/p>\n<p>You can set your campaign and spreadsheet up once, and then let the emails send on autopilot every day, week, or month, based on your business&#8217; needs. Let&#8217;s say you want your email with attachments to send on the first of every month. Just schedule your initial email to send on the first of the month, and then set it to repeat MONTHLY.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb.png\" data-rel=\"lightbox-image-6\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12429\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb.png\" alt=\"automate personalized attachments\" width=\"730\" height=\"747\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb.png 1196w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb-293x300.png 293w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb-768x786.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb-1001x1024.png 1001w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb-24x24.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb-36x36.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/006-automate-personalized-attachments-90kb-48x48.png 48w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p>Now, on the first of every month, GMass will automatically read your spreadsheet, retrieve the files, and send the emails with their corresponding attachment. All you need to do <em>before<\/em> the first of each month is get new files in place, either to your Google Drive, or wherever you&#8217;re hosting them.<\/p>\n<h2>Error handling for missing files or permissions in GMass or Google<\/h2>\n<p>If GMass can&#8217;t retrieve the file for a particular email address, that recipient will be skipped over and you&#8217;ll get a report at the end of the campaign of all recipients who were skipped. If you intentionally <strong>don&#8217;t want certain recipients to receive any attachments<\/strong> with their emails, just <strong>make those cells blank<\/strong> under the &#8220;attachment&#8221; column \u2014 that way, they will still receive the email but without anything attached. It makes sending multiple emails with different needs quite easy.<\/p>\n<p>If you&#8217;re hosting your files on Google Drive, but GMass doesn&#8217;t have permission to read from your Google Drive, then your campaign will error out with this error:<\/p>\n<p><span style=\"font-size: 10pt; color: #ff0000; font-family: 'courier new', courier, monospace;\">Insufficient Permission: Request had insufficient authentication scopes. [403]<\/span><br \/>\n<span style=\"font-size: 10pt; color: #ff0000; font-family: 'courier new', courier, monospace;\">Errors [<\/span><br \/>\n<span style=\"font-size: 10pt; color: #ff0000; font-family: 'courier new', courier, monospace;\">\u00a0 \u00a0 \u00a0 \u00a0 Message[Insufficient Permission: Request had insufficient authentication scopes.] Location[ &#8211; ] Reason[insufficientPermissions<wbr \/>] Domain[global]<\/span><br \/>\n<span style=\"font-size: 10pt; color: #ff0000; font-family: 'courier new', courier, monospace;\">]<\/span><br \/>\n<span style=\"font-size: 10pt; color: #ff0000; font-family: 'courier new', courier, monospace;\">GMass didn&#8217;t have sufficient permissions to your Gmail account to do what you wanted. If you were trying to send personalized attachments, re-connect your Gmail account\u00a0and then click the RESTART link.<\/span><\/p>\n<h2>Using Dropbox to store files for your mail campaign<\/h2>\n<p>If you want to use Dropbox to store the files you want attached to your emails, then you&#8217;ll have to do some manual work \u2014 you&#8217;ll have to create public URLs for each and every single file you want to attach, even if all the files are in the same Dropbox folder. While Dropbox makes it easy to get a public link to a folder, and even a public link to a file, Dropbox <a href=\"https:\/\/www.dropboxforum.com\/t5\/Dropbox-API-Support-Feedback\/links-for-multiple-files-in-a-shared-folder\/td-p\/335074\">does not make it easy to generate public links<\/a> for say, 100 files, without going through the link creation process manually for each of the hundred links you&#8217;ll need for a campaign with multiple emails.<\/p>\n<p>To generate a public link to a file, just right-click the file and choose &#8220;Copy Dropbox Link,&#8221; and then place that URL in the appropriate Google Sheet column.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/007-copy-dropbox-link-224kb.png\" data-rel=\"lightbox-image-7\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12582\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/007-copy-dropbox-link-224kb.png\" alt=\"how to copy dropbox link\" width=\"730\" height=\"747\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/007-copy-dropbox-link-224kb.png 797w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/007-copy-dropbox-link-224kb-293x300.png 293w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/007-copy-dropbox-link-224kb-768x786.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/007-copy-dropbox-link-224kb-24x24.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/007-copy-dropbox-link-224kb-36x36.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/007-copy-dropbox-link-224kb-48x48.png 48w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>But again, you will have to repeat that process for every single file, because there&#8217;s no pattern that you can follow to determine the links yourself. For example, if you have two files in Dropbox, <strong>doc1.pdf<\/strong> and <strong>doc2.pdf<\/strong>, and you generate public URLs to them, they will look like this:<\/p>\n<pre>https:\/\/www.dropbox.com\/s\/bz2536zash23znd\/doc1.pdf?dl=0\r\nhttps:\/\/www.dropbox.com\/s\/kjdjf91w5xuip6n\/doc2.pdf?dl=0<\/pre>\n<p>Now let&#8217;s say you have 100 files for which you need to generate public links. While you can see the left portion of the URL includes &#8220;dropbox.com,&#8221; as expected, and the right portion includes the file name, as expected, there&#8217;s a <strong>unique identifier string inserted in the middle<\/strong> that prevents you from generating these URLs on your own for easy copying and pasting into a Google Sheet that controls multiple emails.<\/p>\n<p>If you do go through the process of manually generating the Dropbox link for each file, then your Google Sheet will look like this:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb.png\" data-rel=\"lightbox-image-8\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12579\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb.png\" alt=\"Google Sheet with manual Dropbox URLs\" width=\"731\" height=\"246\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb.png 1224w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb-300x101.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb-768x259.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb-1024x345.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb-24x8.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb-36x12.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/008-Google-Sheet-with-manual-Dropbox-URLs-137kb-48x16.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><\/p>\n<p><strong>BUT&#8230;<\/strong> those links won&#8217;t work as attachments in that form. Because those URLs actually go to Dropbox pages that display the PDF file, not the PDF file itself. And for this process to work, we need to get at the PDF itself. We&#8217;ll achieve that with <a href=\"https:\/\/help.dropbox.com\/share\/force-download\">Dropbox&#8217;s force download<\/a> feature.<\/p>\n<p>You&#8217;ll need to change the final <code>0<\/code> in each link to a <code>1<\/code>.<\/p>\n<p>So your links would now be:<\/p>\n<pre>https:\/\/www.dropbox.com\/s\/bz2536zash23znd\/doc1.pdf?dl=1\r\nhttps:\/\/www.dropbox.com\/s\/kjdjf91w5xuip6n\/doc2.pdf?dl=1<\/pre>\n<p>If you&#8217;re dealing with lots of links, a find-replace will save you lots of time on this process.<\/p>\n<p>Go to Edit &gt; Find and replace or hit Command\/Control+Shift+H.<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified.png\" data-rel=\"lightbox-image-9\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22867\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified.png\" alt=\"\" width=\"2000\" height=\"1096\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified.png 2000w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified-300x164.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified-1024x561.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified-768x421.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified-1536x842.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified-24x13.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified-36x20.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findreplace-tinified-48x26.png 48w\" sizes=\"auto, (max-width: 2000px) 100vw, 2000px\" \/><\/a><\/p>\n<p>Find <code>dl=0<\/code> and replace it with <code>dl=1<\/code>. I also recommend checking <code>Also search within links<\/code> if you pasted in the Dropbox URLs and Google turned them into links. Click the <strong>Replace all<\/strong> button<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified.png\" data-rel=\"lightbox-image-10\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-22868\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified.png\" alt=\"\" width=\"2000\" height=\"1096\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified.png 2000w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified-300x164.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified-1024x561.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified-768x421.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified-1536x842.png 1536w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified-24x13.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified-36x20.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/dropboxattach-findstring-tinified-48x26.png 48w\" sizes=\"auto, (max-width: 2000px) 100vw, 2000px\" \/><\/a><\/p>\n<h2>Using Amazon S3 to store your attachments<\/h2>\n<p>Using S3 is a much more convenient option than Dropbox to store files for the purpose of personalized attachments, because S3 makes it easy to determine the public URL for any file. By default, an S3 bucket isn&#8217;t public, so make sure that if you create a bucket for the purpose of attaching files to multiple emails, you make your bucket public. You must UNCHECK the &#8220;Block all public access&#8221; box and then CHECK the acknowledgement box:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb.png\" data-rel=\"lightbox-image-11\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12581\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb.png\" alt=\"how to make Amazon S3 bucket public\" width=\"731\" height=\"540\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb.png 1218w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb-300x222.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb-768x567.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb-1024x757.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb-24x18.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb-36x27.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/009-how-to-make-S3-bucket-public-259kb-48x35.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Then, when you upload your files to a bucket, make sure you choose &#8220;Grant public read access&#8230;&#8221; to the objects:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb.png\" data-rel=\"lightbox-image-12\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12583\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb.png\" alt=\"Grant public read access to object in Amazon S3\" width=\"728\" height=\"478\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb.png 1224w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb-300x197.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb-768x504.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb-1024x673.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb-24x16.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb-36x24.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/010-Grant-public-read-access-270kb-48x32.png 48w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n<p>After your files are uploaded, S3 provides you with the public URL for each file, and it&#8217;s simply the DNS name you chose for your bucket in combination with the filename:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb.png\" data-rel=\"lightbox-image-13\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12584\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb.png\" alt=\"Amazon S3 object URL\" width=\"732\" height=\"1019\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb.png 880w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb-216x300.png 216w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb-768x1068.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb-736x1024.png 736w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb-17x24.png 17w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb-26x36.png 26w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/011-Amazon-S3-object-URL-297kb-35x48.png 35w\" sizes=\"auto, (max-width: 732px) 100vw, 732px\" \/><\/a><\/p>\n<p>So in this case, my first two files will have the URL:<\/p>\n<pre>https:\/\/emailattachments.s3-us-west-2.amazonaws.com\/doc1.pdf\r\nhttps:\/\/emailattachments.s3-us-west-2.amazonaws.com\/doc2.pdf<\/pre>\n<p>Note that these URLs don&#8217;t actually work, so don&#8217;t try visiting them! But, any files I upload to this bucket will have a URL in the same format, which means my Google Sheet would look like this:<\/p>\n<p><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb.png\" data-rel=\"lightbox-image-14\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12585\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb.png\" alt=\"Google Sheet with Amazon bucket URLs\" width=\"731\" height=\"227\" srcset=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb.png 1224w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb-300x93.png 300w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb-768x238.png 768w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb-1024x318.png 1024w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb-24x7.png 24w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb-36x11.png 36w, https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/012-Google-Sheet-with-Amazon-bucket-URLs-137kb-48x15.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><\/p>\n<h2>Other mail merge tips and tricks<\/h2>\n<p>What else can you do to make your emails with personalized files even better?<\/p>\n<ul>\n<li>You can send attachments using the <a href=\"https:\/\/www.gmass.co\/blog\/gmass-api\/\">GMass API<\/a>.<\/li>\n<li>Perhaps you don&#8217;t want to attach actual files to your emails, but you instead want to link to a unique file per email address. Here&#8217;s how you can <a href=\"https:\/\/www.gmass.co\/blog\/how-to-include-a-personalized-link-in-a-gmail-email-marketing-campaign\/\">send a campaign with personalized links<\/a>.<\/li>\n<li>If you need a response from your recipients, consider setting <a href=\"https:\/\/www.gmass.co\/blog\/auto-follow-up-emails-until-reply\/\">reply-based follow-ups<\/a> to send automatically.<\/li>\n<li>If you need to <a href=\"https:\/\/www.gmass.co\/blog\/unlimited-mail-merge-sending-gmail\/\">send more emails than your Gmail account allows<\/a>, connect an SMTP service to your account or <a href=\"https:\/\/www.gmass.co\/blog\/use-our-smtp-server\/\">apply to use our in-house SMTP server<\/a>. For example, if you need to send 10,000 customers a personalized PDF every month, you&#8217;ll want to integrate an external SMTP service so that Gmail doesn&#8217;t prematurely bounce your emails.<\/li>\n<li>Make sure your emails with attachments make it to the <strong>Inbox<\/strong> with our <a href=\"https:\/\/www.gmass.co\/blog\/spam-solver-tweaks-emails\/\">Spam Solver<\/a>.<\/li>\n<li>If you ended up here looking for much simpler personalization options, like how to make each email start with &#8220;Dear {FirstName},&#8221; see our <a href=\"https:\/\/www.gmass.co\/blog\/mail-merge-personalization\/\">complete guide to personalization<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever wondered how to send multiple emails with different attachments in Gmail? Well, you can now easily send a mass email or mail merge in Gmail\u2026<\/p>\n","protected":false},"author":2,"featured_media":12436,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4269,19,4263],"tags":[],"class_list":["post-12374","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-email-automation","category-gmail-mail-merge","category-personalization"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>How to send multiple emails with different attachments in Gmail<\/title>\r\n<meta name=\"description\" content=\"Sometimes you need to send a mass email, where each email has a unique personalized attachment. Here&#039;s how you can do that from right inside Gmail.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to send multiple emails with different attachments in Gmail\" \/>\r\n<meta property=\"og:description\" content=\"Sometimes you need to send a mass email, where each email has a unique personalized attachment. Here&#039;s how you can do that from right inside Gmail.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/\" \/>\r\n<meta property=\"og:site_name\" content=\"GMass Blog\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GmailMailMerge\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-05-26T00:11:34+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2024-10-22T17:32:25+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/Featured-image-personalized-attachments.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1001\" \/>\r\n\t<meta property=\"og:image:height\" content=\"467\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"Ajay Goel\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@PartTimeSnob\" \/>\r\n<meta name=\"twitter:site\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ajay Goel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/\"},\"author\":{\"name\":\"Ajay Goel\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"headline\":\"How to send multiple emails with different attachments in Gmail\",\"datePublished\":\"2020-05-26T00:11:34+00:00\",\"dateModified\":\"2024-10-22T17:32:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/\"},\"wordCount\":2108,\"commentCount\":63,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Featured-image-personalized-attachments.png\",\"articleSection\":[\"Email Automation\",\"Gmail Mail Merge\",\"Personalization\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/\",\"name\":\"How to send multiple emails with different attachments in Gmail\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Featured-image-personalized-attachments.png\",\"datePublished\":\"2020-05-26T00:11:34+00:00\",\"dateModified\":\"2024-10-22T17:32:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\"},\"description\":\"Sometimes you need to send a mass email, where each email has a unique personalized attachment. Here's how you can do that from right inside Gmail.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Featured-image-personalized-attachments.png\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Featured-image-personalized-attachments.png\",\"width\":1001,\"height\":467,\"caption\":\"Personalized email attachments\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/mass-email-with-personalized-attachments\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to send multiple emails with different attachments in Gmail\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\",\"name\":\"GMass Blog\",\"description\":\"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/b5fa74f8765b860701158fd77162fff8\",\"name\":\"Ajay Goel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g\",\"caption\":\"Ajay Goel\"},\"description\":\"Ajay is the founder of GMass and has been developing email sending software for 20 years.\",\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/PartTimeSnob\",\"https:\\\/\\\/x.com\\\/PartTimeSnob\"],\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/author\\\/ajay-goel\\\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to send multiple emails with different attachments in Gmail","description":"Sometimes you need to send a mass email, where each email has a unique personalized attachment. Here's how you can do that from right inside Gmail.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/","og_locale":"en_US","og_type":"article","og_title":"How to send multiple emails with different attachments in Gmail","og_description":"Sometimes you need to send a mass email, where each email has a unique personalized attachment. Here's how you can do that from right inside Gmail.","og_url":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2020-05-26T00:11:34+00:00","article_modified_time":"2024-10-22T17:32:25+00:00","og_image":[{"width":1001,"height":467,"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/Featured-image-personalized-attachments.png","type":"image\/png"}],"author":"Ajay Goel","twitter_card":"summary_large_image","twitter_creator":"@PartTimeSnob","twitter_site":"@GMassForGmail","twitter_misc":{"Written by":"Ajay Goel","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/"},"author":{"name":"Ajay Goel","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"headline":"How to send multiple emails with different attachments in Gmail","datePublished":"2020-05-26T00:11:34+00:00","dateModified":"2024-10-22T17:32:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/"},"wordCount":2108,"commentCount":63,"image":{"@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/Featured-image-personalized-attachments.png","articleSection":["Email Automation","Gmail Mail Merge","Personalization"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/","url":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/","name":"How to send multiple emails with different attachments in Gmail","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/Featured-image-personalized-attachments.png","datePublished":"2020-05-26T00:11:34+00:00","dateModified":"2024-10-22T17:32:25+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8"},"description":"Sometimes you need to send a mass email, where each email has a unique personalized attachment. Here's how you can do that from right inside Gmail.","breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/Featured-image-personalized-attachments.png","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2020\/05\/Featured-image-personalized-attachments.png","width":1001,"height":467,"caption":"Personalized email attachments"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/mass-email-with-personalized-attachments\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to send multiple emails with different attachments in Gmail"}]},{"@type":"WebSite","@id":"https:\/\/www.gmass.co\/blog\/#website","url":"https:\/\/www.gmass.co\/blog\/","name":"GMass Blog","description":"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gmass.co\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/b5fa74f8765b860701158fd77162fff8","name":"Ajay Goel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f3a70af05bbabe47925150d5a1320540e801b78055a74da20658fc97cd0706a2?s=96&d=mm&r=g","caption":"Ajay Goel"},"description":"Ajay is the founder of GMass and has been developing email sending software for 20 years.","sameAs":["https:\/\/twitter.com\/PartTimeSnob","https:\/\/x.com\/PartTimeSnob"],"url":"https:\/\/www.gmass.co\/blog\/author\/ajay-goel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/12374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/comments?post=12374"}],"version-history":[{"count":36,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/12374\/revisions"}],"predecessor-version":[{"id":24479,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/12374\/revisions\/24479"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media\/12436"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=12374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=12374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=12374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}