1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Sending Email Reminders to Different people from Excel

Discussion in 'Business Applications' started by nagi71, Oct 16, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. nagi71

    nagi71 Thread Starter

    Joined:
    Oct 16, 2007
    Messages:
    8
    Hi!
    I am using Excel to track many IP deliverables for a project. almost 100 IP's
    In the excel I have Initial/current/Acutal/date of IP delivery.
    Based on the Aligned(Actual) IP delivery scheduled date, I am looking at how to automatically send Email reminder to the IP Provider on or before the aligned from Excel.
    Please do let me know how I can acheive this automation.

    Thanks
    Nagesh
     
  2. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    Can you please post your sample workbook?

    Regards,
    Rollin
     
  3. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
  4. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    But if Ur case is diferent from that please upload a sample file, it will be easyer to find a solution!

    And provide some aditional info, about how U wanna it be done and will see if this is possible!
     
  5. nagi71

    nagi71 Thread Starter

    Joined:
    Oct 16, 2007
    Messages:
    8
    Hello,
    I have attached the excel in Zip format. Please do take a look.
    Thanks
    Nagesh
     

    Attached Files:

  6. nagi71

    nagi71 Thread Starter

    Joined:
    Oct 16, 2007
    Messages:
    8
    HI!,
    I have attached the excel.I finally want to have emails reminders being sent out to the IP Providers based on the CURRENT date in the excel.
    I am new to Excel VBA, using Macros. Your inputs would defintely hlp me.
    Nagesh
     
  7. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    Did U Looked at the link I've posted?
     
  8. nagi71

    nagi71 Thread Starter

    Joined:
    Oct 16, 2007
    Messages:
    8
    HI! Aj,
    I did take a look at the codes...
    As informed I am total stranger to coding. could you please guide me on how to go about this? How I can integrate this in to my excel?
    BR
    Nagesh
     
  9. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    Nagesh could U post the .xls file not zipped or rar one?
     
  10. nagi71

    nagi71 Thread Starter

    Joined:
    Oct 16, 2007
    Messages:
    8
    Attached is the excel.
    I had earlier attached the complete excel in Zip format as the size of the excel was more the allowed upload limit.
    I have removed a couple of sheets & kept the sheets for which I need support.
    Nagesh
     

    Attached Files:

  11. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    OK, now that you posted your workbook explain in detail how you want the macro to work. Which worksheets and which columns will the logic be based on? Also, we need to know which values represent the IP provider and how will the email address to use be determined. The more details you provide the better we can assist you since you are the only one who understands the data layout.

    Also, is there any particular reason why you are not storing your data in Access instead of Excel? A database offers much more flexibility and options such as custom queries and reports.

    Regards,
    Rollin
     
  12. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Now we just need to find someone who knows some VBA. Rollin, do you know anyone who tinkers with VBA code? :D:D
     
  13. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    Nagesh could U give ase more info about the file. I see there 2 Actual date rows!
     
  14. nagi71

    nagi71 Thread Starter

    Joined:
    Oct 16, 2007
    Messages:
    8
    Hi!
    The 3 sheets represent different IP Deliverables.
    There are 4 stages of deliveries. IP releases 0.1/0.5/0.8 & 1.0 during different stages of the Project.
    What really matters is Actual delivery date.
    I use Excel as it is easy to maintain & with each weekly review the Actual date of IP Release varies (In most cases).
    SubFamily is the IP Provider in all the 3 sheets.
    I basically take care of the Project Scheduling/tracking & to a extent Configuration Management (Clearcase).
    Excel is widely used in the design teams with share point. Apart from MS -Project
    At present, it would be nice to have things working in Excel.
    If you take a look at the Zip file, you will see the complete sheets... here I get the graphs based on the first 3 sheets. Also the deliquent/pending deliverables get reflected.. This statistics is what is needed by the Top Management & hence have relied more on Excel.
    The excel in zip is more or less standardized across the business unit.

    Could you also provide me details how I can work with access?
    BR
    Nagesh
     
  15. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    Where should be the email addres to wich email will be send
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/638887

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice