You can actually find all these methods in Google Scripts Documentation (click on the help button on GS UI). I think you might find it surprising because you come from the spreadsheets world or something like that, but it's actually quite simple and popular to create these types of functions, just search for Google Scripts in StackOverflow

same....

@@rafaelwendel1400 please more explain . tanks

script.google.com/home

Have you figured it out?

Yes! Watch the video right through. There's a line of code he adds to create a page break in the function, so you get a separate document for each line of the spreadsheet.

have you found a solution?

Yes - i am facing the same issue - did you rectification ! any solutions available ?

@@guruslakkimar12 I have created a copy function which works: //copy doc function copyContentDoc(filename=null) { var sourceDoc = DocumentApp.getActiveDocument().getBody(); if(filename === null){ filename = 'Kopie van_'+DocumentApp.getActiveDocument().getName(); } var targetDoc = DocumentApp.create(filename); var totalElements = sourceDoc.getNumChildren(); for( var j = 0; j < totalElements; ++j ) { var targetBody = targetDoc.getBody(); var element = sourceDoc.getChild(j).copy(); var type = element.getType(); var attributes = element.getAttributes(); if( type == DocumentApp.ElementType.PARAGRAPH ){ targetBody.appendParagraph(element); } else if( type == DocumentApp.ElementType.TABLE){ targetBody.appendTable(element).setAttributes(attributes); } else if( type == DocumentApp.ElementType.LIST_ITEM){ targetBody.appendListItem(element).setAttributes(attributes); } else if( type == DocumentApp.ElementType.PAGE_BREAK){ targetBody.appendPageBreak(element).setAttributes(attributes); } else if( type == DocumentApp.ElementType.HEADER_SECTION){ targetDoc.addHeader().setText(element).setAttributes(attributes); } else if( type == DocumentApp.ElementType.FOOTER_SECTION){ targetDoc.addFooter().setText(element).setAttributes(attributes); } // ...add other conditions of DocumentApp.ElementType } targetDoc.saveAndClose(); return true; }

I had the same questions and after a lot of tinkering, got it to work. You need to append a Table to the final doc first and pass it to the mailMerge function. Then, inside the mailMerge function (before the forEach statement), you append a row to the table and set the row's minimum height to the height of your label. You also append a cell to the row. Then, inside the forEach statement, append the mail merge data (from this tutorial) to the cell. In my case, I wanted two columns of labels, so in the final doc, I manually set it to be two columns. I couldn't find a way do do that with Google Scripts, but fortunately, formatting it to two columns works just great. The table cell fills the entire width of the column (or document if you don't make columns). Finally, because a table has to have a paragraph before it, it seems to mess up the first column of labels on the first page. I was able to fix this by using google scripts to set the final document body font to size 1 and the document spacing to .06. You can't tell the paragraph is there and my labels work great! Lifesaver for my own project and this tutorial got me started! Thanks!

It definitely is easier for someone who is used to doing it and someone who is fairly tech literate, but I have a mail merge that needs to be completed on a regular basis by some people who aren't terribly computer savvy. It was more work for me to set it up initially, but now for all the other users, they click a button to run the script and the merge is automatically completed for them. Way easier for them to use than for me teaching them how to do a Word merge.

If you want to send emails you should be using HTML not Google Docs. Here is an example kzfaq.info/get/bejne/npiqZJaKqpnPeps.html

Create 2 templates, get the ID, set var for each of them. Use if condition in the script pointing to the template (x or y).

Glad to hear that!

I had a similar problem. You probably aren't passing in the correct number of parameters as per the function declaration.

Have another vídeo to show how yo create a new single document for each ss row?

Was this ever figured out?

Probably :) I'm sure people who already know programming will figure that out themselves.

@Rafael Wendel - why would it be better? I'm interested from the perspective of a novice coder.

Hi do you solved this problem?

Not through GMail UI, but sending email through GMail kzfaq.info/get/bejne/npiqZJaKqpnPeps.html

I had same issue. I removed my image - ran it - then put image back.

it's possible. Watch my apps script series array methods videos, in particular filter method.

kzfaq.info/get/bejne/fp2Hec6lm7CYoqc.html

No, but you can use JavaScript filter method kzfaq.info/get/bejne/hrqPh6eZss67o3k.html

did you find a solution to this?

@@mariop4211 not yet. I gave up and started using MSword for it

If it says there is no somevar.forEach that means you had a problem in the line before where you defined somevar.

@@goldenwilliams the problem for me was ensuring that I told the function to include another r(i) value

@@ExcelGoogleSheets First off thanks for the video! Secondly I inputed a table into my template Doc, and it doesn't show in the final Doc. Any advice?