Thunderbird Portable can run from a USB stick and leaves no hard disk footprint meaning you can use it with ease anytime, anywhere. Select the Drive folder that contains the files.If you're always on the move and a big Thunderbird fan, then this program should answer a lot of your prayers.Click + Alias, filters, personalized attachments and click Import from Drive folder.In the Google Sheets, select Add-ons > Yet Another Mail Merge > Start Mail Merge.For more than 100 attachments, you should consider an appropriate number of digits to ensure accurate matches. Note: The ID here is a three-digit number. In a new column, list the ID values for each recipient so that they match the ID values in the filename of the personalized attachment for that recipient.Open the Google Sheets for the mail merge.Choose a naming convention for your file titles that include the ID.If an ID appears in multiple filenames (for example, 01 is found in 01 and in 101), all files matching the ID are sent to the same recipient. YAMM personalizes the attachments by using the unique IDs which are part of the filename naming convention. In our example, we are sending personalized monthly payslips in attachments to our employees. If you have a lot of attachments, you can add them automatically in your Google Sheets.
Method 2: Automatically list all file URLs in your Google Sheets
Select the checkbox Attach files in column xx to emails sent.Click + Alias, filters, personalized attachments.If the column name does not match Attachment, YAMM does not detect it and it cannot attach the listed documents. Warning The name of the attachments column is case-sensitive and its name must be Attachment.
0 kommentar(er)
