+ Reply to Thread
Results 1 to 2 of 2

Want to Use Google Sheet which can send the emails once the data is captured automatically

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Want to Use Google Sheet which can send the emails once the data is captured automatically

    Want to Use Google Sheet which can send the emails once the data is captured automatically

    Dear Forum,

    I have never used Google Sheets till now, but I was made aware of the amazing possibilities that can be attained while using the same, I use excel files but this being more dynamic as its on the Cloud will be more useful if it could achieve some things more that I intend to envisage in my file.

    I send a particular file to each Sales Region so that they can populate the information of how much business was done in that Region which is divided into number of Locations/Cities, now each Region is termed as a "Branch" in our organisation and each Branch has several different Locations, so in a Region there are several different people who take care of this location and hence the information has to be entered by Multiple People, in the present context where I send them Excel files they are sent back to me with only few locations filling their details whereas the expectation is to have the entire information for the Region duly complete then the file sent back to me...

    However, the sales team have to be continuously reminded, so a lot of to and fro emails take place and a lot of time is invested for this simple task..

    I want to employ Google Sheets in such a way that once the file is sent then each person can fill their details and then till the time information is not complete they keep on getting Automatic Emails reminding them that this work is still pending..I would like to set a Time-Frame and then once the links is shared the Count-Down Begins.

    Is this possible...and how to achieve the same, would also appreciate if some informative stuff or links are shared.

    Warm Regards
    e4excel

  2. #2
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Want to Use Google Sheet which can send the emails once the data is captured automatic

    I am looking to get some help or any notes to do the following.


    Access, create, edit, and print
    Share and collaborate
    Spreadsheet basics
    Smarter project sheets
    Formulas and function guide via help
    Track on the Revision History of the sheet
    Auto Save in Google Sheets
    Protection of the sheets
    Email to collaborators
    Email as an attachment
    All about Google Sheets- Introduction, Importance & features
    Learn various Formulas available: V/H Lookup, Importrange, .
    Sort, Summarize and filter data/Filter View
    Different charts type-Sparkline, Geo.TreeMap, Candlestick, Line Pie, Scattered, Annotated charts etc.
    Consolidation of Multiple sheets in One Master sheet.
    Sharing Permissions on workbook/sub-sheets/rows/columns.
    Usage of Pivot Tables., Data Validation, Conditional Formatting,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vba to fetch email id and send emails automatically
    By abi123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2017, 04:22 AM
  2. Macro to send automatically emails to different people with attachments
    By Dr.Tenma in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2015, 08:38 AM
  3. Any Excel code to send emails automatically
    By knighty2002uk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 05:55 AM
  4. How to convert my macro to send emails automatically
    By nje in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2013, 04:48 PM
  5. Replies: 0
    Last Post: 02-03-2013, 03:40 PM
  6. [SOLVED] VBA Coding To Automatically Send Emails Within a Column of Values
    By zeeez in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-22-2012, 05:57 PM
  7. Use excel to automatically send emails
    By cannon_lab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2007, 06:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1