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.

Need Help reg "Automatic email from excel based on date "

Discussion in 'Business Applications' started by samd007, Aug 16, 2012.

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

    samd007 Thread Starter

    Joined:
    Jun 12, 2012
    Messages:
    10
    Hi ! This refers to the subject of "Automatic email from excel based on date", and relevant thread http://forums.techguy.org/business-applications/927675-solved-automatic-email-excel-based.html

    This was fantastic. Only one issue remaining.
    This is generating multiple emails and even the items not due are generating blank mails.
    I would like to generate only one mail with different items different expiration dates.
    After that group the identical addressees and compose one message with all the relevant data.
    Awaiting kind help.
     

    Attached Files:

  2. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
  3. samd007

    samd007 Thread Starter

    Joined:
    Jun 12, 2012
    Messages:
    10
    Many thnaks for your thread, I wanted something like that only, but that seems to be customized for Lotus Notes.
    Please find attached the excel I was working on & designed for working with Groupwise mail. Only problem is, it generates multiple emails for each item (even blank mails for the items not due/coming due).
    I want to make it in one consized mail with only the overdue/coming due data.
    How do I achieve same?
     

    Attached Files:

  4. samd007

    samd007 Thread Starter

    Joined:
    Jun 12, 2012
    Messages:
    10
    Nobody ??
     
  5. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Code includes collection datatype, as I assume you have excel 2007 or later.
     

    Attached Files:

  6. samd007

    samd007 Thread Starter

    Joined:
    Jun 12, 2012
    Messages:
    10
    Hello,

    Many thanks for the effort. But it still sends out multiple emails for different equipments. The ones coming due or overdue - separate emails going out for each of them. Example - The mail body reads:
    Please take notice of the following expiration date(s):
    -Equipment E Job eeeee expiration date : 16/06/2012 -80 days.
    -Equipment E Job eeeee OVERDUE : 16/06/2012 -80 days.
    Sent at 04/09/2012 10:01:40 AM

    And the ones not due, going blank, i.e: the mail body text reads: "
    Please take notice of the following expiration date(s):
    Sent at 04/09/2012 10:01:39 AM"

    What I wanted was a single mail with following in the mail body (Example):
    Please take notice of the following expiration date(s):

    -Equipment A Job aaaaa expiration date : 19/08/2012 -16 days.
    -Equipment A Job aaaaa OVERDUE : 19/08/2012 -16 days.
    -Equipment B Job bbbbb expiration date : 29/08/2012 -6 days.
    -Equipment B Job bbbbb OVERDUE : 29/08/2012 -6 days.
    -Equipment C Job cccccc expiration date : 11/09/2012 7 days.
    -Equipment E Job eeeee expiration date : 16/06/2012 -80 days.
    -Equipment E Job eeeee OVERDUE : 16/06/2012 -80 days.

    A message reminding you was sent on 21/08/2012
    No action has yet been taken.
     
  7. 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/1065396