+ Reply to Thread
Results 1 to 1 of 1

Complex Excel project with automatic email data collection

  1. #1
    Registered User
    Join Date
    06-06-2019
    Location
    Cyprus
    MS-Off Ver
    365
    Posts
    10

    Complex Excel project with automatic email data collection

    Good day to you, my dear friends.

    I've been cracking at this for a little while now, working on a complex excel tree with a bunch of different tasks.
    The basic idea is to make a set of excels starting with an “input/macro trigger”(aka "email sender") excel, that sends emails from "mailbots" based on input in the “email sender” file (mailbots are for different recipients and exact ones are selected from the input file((so some "mailbots” won’t have to be used))). After the macro trigger, inputted data will copy to a separate sheet with a general table for the selected user that will later become a part of the main table("database") with all information from all users. The data can be updated every day or every time the e-mail macro is activated.

    Also I'm sure this has been done part by part in some sort of way, so I'm working with forum archives to claw out some tips and will be posting updates as I go, but if anyone has experience with problems so complex, any help would be appreciated.
    Thank you in advance.

    Posted all 3 excels in attachment for more details:
    Attached Files Attached Files

+ 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. When i enter Project No the data should be populate automatic.Please help
    By thermax1829 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2014, 02:02 AM
  2. Automatic Email from Excel after sorting data
    By panx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2014, 02:13 AM
  3. Automatic update from excel to existing MS Project
    By Pierrejza in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2014, 01:35 AM
  4. Complex Data Analysis Project
    By CapstanJD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2014, 10:18 AM
  5. Can excel send an automatic email via outlook? It get's a lot more complex...
    By BGibbons92 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-27-2012, 05:07 PM
  6. Automatic email of excel contents as email body
    By naveenn08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2009, 08:26 AM

Tags for this Thread

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