-
Notifications
You must be signed in to change notification settings - Fork 0
fmontemorano/GmailMerge
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
<h2> </h2> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="font-size: 27px; font-family: Arial; color: rgb(153, 153, 153); background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">GmailMerge</span></span></p> <hr /> <ul style="margin-top:0pt;margin-bottom:0pt;"> <li dir="ltr" style="list-style-type: disc; font-size: 19px; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="color: rgb(67, 67, 67); background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">What is it?</span></span></p> <ul style="margin-top:0pt;margin-bottom:0pt;"> <li dir="ltr" style="list-style-type: circle; font-size: 15px; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">A macro for Gmail written in Google Apps Script.</span></span></p> </li> </ul> </li> <li dir="ltr" style="list-style-type: disc; font-size: 15px; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="font-size: 19px; color: rgb(67, 67, 67); background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">What is it for?</span></span></p> <ul style="margin-top:0pt;margin-bottom:0pt;"> <li dir="ltr" style="list-style-type: circle; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Sending mass mail merges.</span></span></p> </li> </ul> </li> <li dir="ltr" style="list-style-type: disc; font-size: 15px; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="font-size: 19px; color: rgb(67, 67, 67); background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">How does it work?</span></span></p> <ul style="margin-top:0pt;margin-bottom:0pt;"> <li dir="ltr" style="list-style-type: circle; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">The macro creates and sends emails based on the information you specify;</span></span></p> <ul style="margin-top:0pt;margin-bottom:0pt;"> <li dir="ltr" style="list-style-type: square; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Name of recipient</span></span></p> </li> <li dir="ltr" style="list-style-type: square; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Address of recipient</span></span></p> </li> <li dir="ltr" style="list-style-type: square; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Attachment</span></span></p> </li> <li dir="ltr" style="list-style-type: square; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Text Body</span></span></p> </li> </ul> </li> </ul> </li> <li dir="ltr" style="list-style-type: disc; font-size: 15px; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="font-size: 19px; color: rgb(67, 67, 67); background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">How do I use it?</span></span></p> <ul style="margin-top:0pt;margin-bottom:0pt;"> <li dir="ltr" style="list-style-type: circle; font-size: 19px; color: rgb(67, 67, 67); background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="font-size: 15px; color: rgb(0, 0, 0); background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Before starting make sure that you go to Google Contacts (</span><a href="https://mail.google.com/mail/u/0/?tab=mm#contacts" style="text-decoration:none;"><span style="font-size: 15px; color: rgb(17, 85, 204); background-color: transparent; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">https://mail.google.com/mail/u/0/?tab=mm#contacts</span></a><span style="font-size: 15px; color: rgb(0, 0, 0); background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">) and create the group to which you are planning on sending your mail merge.</span></span></p> </li> <li dir="ltr" style="list-style-type: circle; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Open Google Apps Script (</span><a href="https://script.google.com/macros/" style="text-decoration:none;"><span style="color: rgb(17, 85, 204); background-color: transparent; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">https:script.google.com/macros</span></a><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">) and create a "blank project".</span></span></p> </li> <li dir="ltr" style="list-style-type: circle; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Copy and paste the code, then hit save (name it whatever you want).</span></span></p> </li> <li dir="ltr" style="list-style-type: circle; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Run "CreateSpreadsheet".</span></span></p> </li> <li dir="ltr" style="list-style-type: circle; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">It will ask you to authorize, after you authorize:</span></span></p> <ul style="margin-top:0pt;margin-bottom:0pt;"> <li dir="ltr" style="list-style-type: square; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Re-run “CreateSpreadsheet” then go to Gdrive and open your spreadsheet.</span></span></p> </li> <li dir="ltr" style="list-style-type: square; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Fill out cell H1 of your spreadsheet with the name of the group that will receive your mail merge.</span></span></p> </li> <li dir="ltr" style="list-style-type: square; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Run “LoadContacts”.</span></span></p> </li> <li dir="ltr" style="list-style-type: square; background-color: transparent; vertical-align: baseline;"> <p dir="ltr" style="line-height:1.15;margin-top:0pt;margin-bottom:0pt;"> <span id="docs-internal-guid-2427345f-f6c1-fe7d-a614-cc69facb927d"><span style="background-color: transparent; vertical-align: baseline; white-space: pre-wrap;">Once your finished, run “SendMessages” (note: there are no safety features on this prototype macro).</span></span></p> </li> </ul> </li> </ul> </li> </ul>
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published