I have a Google spreadsheet that contains recipient's names, emails, and a message that anonymous people have sent this Valentine's Day.  I am aware of applications such as the various Mail Merges that allow one to send personalized messages. All of which that I have found, however, send in plaintext  (at least in their free versions).  In the Mail Merge add-ons I have used, I can't seem to include images either.  I am also aware of scripts that can send HTML emails, but none that can send personalized emails automatically to a large number of people. An example message I am looking for may just be something like a simple banner image, greeting (with variable name), and variable message, perhaps with everything centered. The easiest way I can think of to achieve this is by sending an HTML email, so I'm looking for a way to retrieve spreadsheet values for a template HTML document to send the personalized messages.
Here's an example of a Google Docs Spreadsheet script that sends emails using Google spreadsheets. I want the email Sent in HTML not plain text. Can someone help me out?  function sendEmails() {   var sheet = SpreadsheetApp.getActiveSheet();   var startRow = 2;  // First row of data to process   var numRows = 2;   // Number of rows to process   // Fetch the range of cells A2:B3   var dataRange = sheet.getRange(startRow, 1, numRows, 2)   // Fetch values for each row in the Range.   var data = dataRange.getValues();   for (i in data) {     var row = data[i];     var emailAddress = row[0];  // First column     var message = row[1];       // Second column     var subject = "Sending emails from a Spreadsheet";     MailApp.sendEmail(emailAddress, subject, message);   } }
I'm writing code to do Xml serialization. With below function.  public static string SerializeToXml(object obj) {     XmlSerializer serializer = new XmlSerializer(obj.GetType());     using (StringWriter writer = new StringWriter())     {         serializer.Serialize(writer, obj);         return writer.ToString();     } }   If the argument is a instance of class without parameterless constructor, it will throw a exception.     Unhandled Exception:   System.InvalidOperationException:   CSharpConsole.Foo cannot be serialized   because it does not have a   parameterless constructor.    at   System.Xml.Serialization.TypeDesc.CheckSupported()   at   System.Xml.Serialization.TypeScope.GetTypeDesc(Type   type, MemberInfo sourc e, Boolean   directReference, Boolean throwOnError)   at   System.Xml.Serialization.ModelScope.GetTypeModel(Type   type, Boolean direct Reference)    at   System.Xml.Serialization.XmlReflectionImporter.ImportTypeMapping(Type   type , XmlRootAttribute root, String   defaultNamespace)    at   System.Xml.Serialization.XmlSerializer..ctor(Type   type, String defaultName space)    at   System.Xml.Serialization.XmlSerializer..ctor(Type   type)   Why must there be a parameterless constructor in order to allow xml serialization to succeed?  EDIT: thanks for cfeduke's answer. The parameterless constructor can be private or internal. Pgfplots: How to fill area under a curve in a 3d plot similar to \closedcycle in 2d How can I fill the area under a curve in a 3d plot, similar to the \closedcycle command in ordinary 2d plots? Applying this command does a filling which is not rotated.  Minimal working example:  \documentclass{article}  \usepackage{tikz} \usepackage{pgfplots} \begin{document}   \begin{tikzpicture}      \begin{axis}[     xmin=0,xmax=3,     zmin=0,zmax=2     ]         \addplot3[red,domain=0:1,fill=blue,opacity=0.5,samples y=0] (2,x,x^2) \closedcycle ;      \end{axis}   \end{tikzpicture} \end{document}   In 2D it looks like this  \documentclass{article} \usepackage{tikz} \usepackage{pgfplots} \begin{document}   \begin{tikzpicture}   \begin{axis}[domain=0:1     ]         \addplot[red,domain=0:1,fill=blue,opacity=0.5,samples y=0] {x^2} \closedcycle ;   \end{axis}   \end{tikzpicture} \end{document}   How can I easily apply this to a 3D plot? I submitted a manuscript last year to an IEEE journal, and the paper was accepted for publication. I recently submitted a new manuscript to the same journal, but, this time, the paper was rejected, and I was told that I should submit to another journal since my paper was not within the journal's scope. The two papers both target similar applications. Furthermore, the second paper uses some work in the first paper, making substantial improvements at solving a much more difficult problem. Based on the reviewer's comments (and my own personal assessment), I do not believe that the work presented in the second paper was "incremental" in nature. Far from it. Two of the three reviewers gave positive reviews. The third reviewer, however, mentioned the "outside of journal's scope" issue and the associate editor and editor-in-chief both sided with the 3rd reviewer, and the paper was stopped dead in its tracks.  I'm scratching my head trying to come to terms with how in the world my first paper could be accepted by this journal, but the second paper focused on the same application space and achieving substantial improvements on a much more difficult problem (backed up with measured results) could be rejected. Any ideas? Graph nodes coordinates evaluation I tried to follow the new Blender 2.8 tutorial from Blender Guru.   When entering "Sculpting" with the icing there were suddenly alot of holes in it. Why is this? 18.04.01 Not available for server In PHP you can just use $_POST for POST and $_GET for GET (Query string) variables. What's the equivalent in Python? beamer - global transition shifts slide content Using beamer with the , I want to have a global transition effect (a fast fade) which I set using the following code:  \addtobeamertemplate{background canvas}{\transfade[duration=0.2]}{}   as found on  answer.  However, doing it messes up with my slides settings. It doesn't change every slides, only the \section ones that are slightly shifted to the right, adding a white line on the left, as seen here:   I tried using XeLaTeX and LuaLaTeX, as they are the only compilers I could use for my current font, but they both have the same issue.  It probably comes from the theme, however I have no clue why it would happen or how to fix it.  Edit :   \documentclass{beamer} \usetheme{m} \addtobeamertemplate{background canvas}{\transfade}{}  \begin{document} \section{test} \end{document}   Requires the mtheme to work How to install Ubuntu on VirtualBox? Are smaller p-values more convincing? Creating a single index from several principal components or factors retained from PCA/FA I am using Principal Component Analysis (PCA) to create an index required for my research. My question is how I should create a single index by using the retained principal components calculated through PCA.  For instance, I decided to retain 3 principal components after using PCA and I computed scores for these 3 principal components. What is the appropriate ways to create, for each respondent, a single index out of these 3 scores?   Is it relevant to add the 3 computed scores to have a composite value? Or to average the 3 scores to have such a value?  Or should I just keep the first principal component (the strongest) only and use its score as the index?   Alternatively, one could use Factor Analysis (FA) but the same question remains: how to create a single index based on several factor scores? Lyman and Balmer series When you suggest an edit to a post and view the post while it's pending, . But as noted in the , this linking hasn't been implemented for tag wikis/excerpts yet, partly because there are potentially two links to include and the wording is not entirely obvious, and partly because they're orders of magnitude less common.  Here's my suggested wording for the three cases.   Tag wiki excerpt only     Thanks for your edit!   This edit will be visible only to you until it is .  Tag wiki only     Thanks for your edit!   This edit will be visible only to you until it is .  Both     Thanks for your edit!   These edits will be visible only to you until they are peer reviewed (, ).        I can't directly address the prioritization of tag wiki edits, but I'd appreciate the corresponding  or  mark, at least. Group of $r$ people at least three people have the same birthday? What is the probability that in a randomly chosen group of $r$ people at least three people have the same birthday?   $\displaystyle 1- \frac{365\cdot364 \cdots(365-r+1)}{365^r}$   $\displaystyle \frac{365\cdot364         \cdots(365-r+1)}{365^r} +{r\choose 2}\cdot \frac{365\cdot364\cdot363 \cdots         (364-(r-2) +1)}{364^{r-2}}$  $\displaystyle 1- \frac{365\cdot364             \cdots(365-r+1)}{365^r} +{r\choose 2}\cdot \frac{365\cdot364\cdot363 \cdots (364-(r-2) +1)}{364^{r-2}}$  $\displaystyle\frac{365\cdot364 \cdots(365-r+1)}{365^r}                 $     My attempt :  (May be typo in option $(3)$ of question !)  $$P(\text{at least 3 persons have same birthday})$$  $$= 1 - \{P\text{(no one has same birthday) + P(any 2 have same birthday)\}}$$  So, option $(3)$ is true.     Can you explain it, please?   It  before,  but I'm not satisfied by explanation. Why and how do "bigger pixels" make a better picture? This is going off of today's iPhone 5S announcement, when Phil Schiller said that "bigger pixels" is the key to a better picture.      What does this mean? Is it true or just a marketing ploy? $dx$ appears in differential equations, such us derivatives and integrals.  For example, a function $f(x)$ its first derivative is $\dfrac{d}{dx}f(x)$ and its integral $\displaystyle\int f(x)dx$. But I don't really understand what $dx$ is. Reference - What does this error mean in PHP? Flying EU to UK to EU. Can I get duty free alcohol? On the 20 of March this year I will be flying from Ireland to the UK and then on the another EU country.  Can I buy duty free alcohol (as in alcohol with no tax) leaving the UK ? Big O, how do you calculate/approximate it? Most people with a degree in CS will certainly know what . It helps us to measure how well an algorithm scales.   But I'm curious, how do you calculate or approximate the complexity of your algorithms? mysqli bind_param for array of strings