
A google app script with a loop and a mail function
- or -
Post a project like this3638
£50(approx. $66)
- Posted:
- Proposals: 2
- Remote
- #841942
- Awarded
Description
Experience Level: Intermediate
General information for the business: We report monthly details to national accounts
Kind of development: Customization of existing program
Num. of modules: 2
Description of every module: module 1; I have made a google sheet with all the sum formulas in. What i need now is some scripting writing to "on click" take row of a data (three at a time) and email them to a static email address (a different one for each contract).
module2; after the emails i want a script that "archives the data and leaves the spreadsheet blank (withformulas) to be filled in for another month.
optional. Have another tab with the email addresses in for easy edit.
Description of requirements/functionality: @ to split the data into groups (three rows at a time) and email them to a specific address (include top header rows in all emails)
@ to archive the data each month (when the function is run) to another file
@have a tab that lists the email addresses or a cell location in the spreadsheet for easier editting
@populate the data into a doc doc and email the link instead of putting it in the email body.
Specific technologies required: Google Apps Script
OS requirements: Windows, Other
Extra notes: All files are google sheets files which i can share with you on take up of the job.
Kind of development: Customization of existing program
Num. of modules: 2
Description of every module: module 1; I have made a google sheet with all the sum formulas in. What i need now is some scripting writing to "on click" take row of a data (three at a time) and email them to a static email address (a different one for each contract).
module2; after the emails i want a script that "archives the data and leaves the spreadsheet blank (withformulas) to be filled in for another month.
optional. Have another tab with the email addresses in for easy edit.
Description of requirements/functionality: @ to split the data into groups (three rows at a time) and email them to a specific address (include top header rows in all emails)
@ to archive the data each month (when the function is run) to another file
@have a tab that lists the email addresses or a cell location in the spreadsheet for easier editting
@populate the data into a doc doc and email the link instead of putting it in the email body.
Specific technologies required: Google Apps Script
OS requirements: Windows, Other
Extra notes: All files are google sheets files which i can share with you on take up of the job.

Michael S.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
33%
Last project
11 Aug 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies