Profile

Cover photo
Jason Sanford
Attended Appalachian State University
151 followers|44,645 views
AboutPostsPhotosYouTube

Stream

Jason Sanford

Shared publicly  - 
 
Perfect timing. I think I'll use this.
L. Brent Gilmore originally shared:
 
Google Apps Script for HTML email with Google Maps API plug-in

After sending the email I've had a number of requests to explain how. So....

My wife and I recently moved into a new house. We needed to send an address update to our contact list but didn't want to go through a printer then stuffing, sealing, stamping and writing out addresses. Given my love of all things Google and my new found curiosity of Google Apps Scripts I wanted to use a Script to:
- Send and HTML email; nice design and picture of the house
- Email our entire contact list in one send
- I wanted it to be free and send from my personal email address
- Use personalization; Dear William
- Google Maps integration

Queue a Google Apps Script and the deign stylings of my buddy +William Hodges. With the script I was able to:
- Create a custom HTML design
- Email our entire list from my Gmail account
- Include personalization
- Provide a Google Map and driving directions from the recipients address to our new address

It turned out great and was extremely simple. If you can type you can send a custom HTML email in minutes (screencaps attached).

If you want the Gdoc Spreadsheet with the script, grab it here:
http://go.lbrentgilmore.com/xhbkz (if you decided to use it, please 'Make a Copy')

#googleappsscript #gmail +Kairyl Ikbal +Neer Patel +Jon Sander +Kevin Kerner +Stefan von Ellenrieder
5 comments on original post
1
Add a comment...

Jason Sanford

Shared publicly  - 
 
Excited about heading to the Googleplex tomorrow for Google's Geospatial Awareness Day event.
Find local businesses, view maps and get driving directions in Google Maps
1
Add a comment...

Jason Sanford

Shared publicly  - 
 
Back to NC for a week of vacation at Lake Norman
1
Steve Farrell's profile photo
 
Don't catch all the fish in Norman. Enjoy.
Add a comment...
In his circles
69 people
Have him in circles
151 people
Knut Jetlund's profile photo
Anna Maria Kotlowska's profile photo
Atanas Entchev's profile photo
Coleman McCormick's profile photo
Bryan McBride's profile photo
Bill Brown's profile photo
Justin Robinson (Xemoka)'s profile photo
Coleman McCormick's profile photo
Melissa Allan's profile photo

Jason Sanford

Shared publicly  - 
 
Chances of a white christmas are good. Oh wait, I'm flying back to NC on Wednesday.
1
Add a comment...

Jason Sanford

Shared publicly  - 
 
Mom shops. We play.
1
Add a comment...

Jason Sanford

Shared publicly  - 
2
Steve Farrell's profile photo
 
Great pictures. Is this your back yard?
Add a comment...

Jason Sanford

Shared publicly  - 
1
Steve Farrell's profile photoJason Sanford's profile photo
3 comments
 
Hmmm, this is what happens when you upload a photo from your phone and never go back to see what it looked like. Sorry for the dirt.
Add a comment...
People
In his circles
69 people
Have him in circles
151 people
Knut Jetlund's profile photo
Anna Maria Kotlowska's profile photo
Atanas Entchev's profile photo
Coleman McCormick's profile photo
Bryan McBride's profile photo
Bill Brown's profile photo
Justin Robinson (Xemoka)'s profile photo
Coleman McCormick's profile photo
Melissa Allan's profile photo
Education
  • Appalachian State University
    Geography/GIS, 2001 - 2005
Links
Work
Occupation
GeoWeb
Basic Information
Gender
Male