When prompted enter or copy-paste the subject line used in your draft Gmail message. Always be super careful when authorizing scripts and third-party apps in general. Important note: The script we are using has been created and proofread by Google Apps Script teams. Read the authorization notice and continue This item menu was created by the Apps Script project and will start the mail merge process.ĥ. Back in the copied spreadsheet, click on the custom menu item called “Mail Merge” and then click on “Send Emails” This indicates text you’d like to be replaced with data from the copied spreadsheet.Ĥ. */ function onOpen () which correspond to column names of the spreadsheet you just copied. * Creates the menu item "Mail Merge" for user to run scripts on drop-down. */ const RECIPIENT_COL = " Recipient " const EMAIL_SENT_COL = " Email Sent " /** * recipient addresses and email sent column. * Change these to match the column names you are using for email See the // License for the specific language governing permissions and limitations under // the License. You may obtain a copy // of the License at // // // // Unless required by applicable law or agreed to in writing, software // distributed under the License is distributed on an "AS IS" BASIS, WITHOUT // WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. Copyright Martin Hawksey 2020 // // Licensed under the Apache License, Version 2.0 (the "License") you may not // use this file except in compliance with the License.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |