![]() ![]() So, paste your data here and make sure you have the first row with column titles.Why the Quicklution Mail Merge add-on is the best mail merge for Google Docs:Įasy mail merge installation and free mail merge for your first 20 mergesįree mail merge online support for both free and premium customers, including 24/7 fast remote support, how to mail merge help and FAQs and video tutorials You will use these column titles in your Google document to mark the field where you want the merged data to appear. The column title is the most important here. The second sheet “PrintMerge” contains the options and the Print Merge button to run the Script and do a Print Merge or a Mail Merge. The spreadsheet contains 2 sheets, in the first sheet “Print Merge Data” you can add the data that you want to use in the merge process. Click on the “Make a Copy” button and a copy of the spreadsheet will be created in your Drive. The previous link will open a new tab in your browser and it will give you an option to Make a Copy of the spreadsheet. Get the Print Merge Spreadsheet Detail instructionsįirst, you need to get the spreadsheet in your Drive. To get your copy of the spreadsheet just click on the following link: Sometimes it will display an error, just dismiss it and run the script again If this is the first time you are running the script you have to accept the permissions.Next, press the Print Merge button and that’s it.The last option lets you select the type of output document.You can also use data from the columns to construct the name of the document Next, you can define the name of the merge documents, if you leave it empty it will use the name of the template file with a counter on the end (1, 2, 3, …).If you are sending emails, on the next row add the Subject and the text for the email message.To send emails with the merged documents select the check box and on the next row (Email column number) specify the column with the email address.Copy and paste the Google folder link if you want the document saved in a different folder, if not leave it empty.Copy and paste the Google doc link in the “Google Doc template (link):” field in the “PrintMerge” sheet.Create a Google Doc (template) and add the Column Title in double curly brackets (like this, how are you).Add column titles and add or paste your data in the “Print Merge Data” sheet.*if you need extra options just send a request in the comments If you select Google doc for a Mail merge, the attachment is converted and sent in Microsoft Word document format.Specify the column with the email address. ![]() Specify a folder where you want the files to be created.With this Google Spreadsheet for Print merge or Mail merge for Google docs you can: I have been using this Google spreadsheet script to do a Print merge for a while and I have made small adjustments so it can be used by everybody.īasically, this is a Google Spreadsheet with a Script that you can paste your data in it and do a Print Merge or a Mail merge with a Google doc template, you just have to match the column names in the spreadsheet with the text in the Google Doc. Usualy these add-ons have limited options and are missing some of the needed functions. Google Docs doesn’t have the Print Merge or a Mail Merge option available, so if you want to create multiple documents from the data you have in your spreadsheet you have to use an Add-on. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |