+ Reply to Thread
Results 1 to 14 of 14

Sending emails and alerts

  1. #1
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Sending emails and alerts

    I m using excel 2003.
    I required email alert massage at my mail id & also copy mark to our higher officials.

    In sheet1 : Q2 & Q3 display today system date
    Now in column e2 to p2 & e3 to p3 visit due date.

    I required alert mail before 4 days from the date of visit due date. & mail sending every day with back counting of days i.e. 4 day left, 3 day left, 2 day left & on due date high alert massage pass with red colur.

    I m attaching file for your ready ref. .
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: email alert notification

    bump no reply. Awaiting

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: email alert notification

    Awating favourable reply. Anyone solved our problem. Can be possible through vb. i m beginer in vb field. Hence co-oprate.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: email alert notification

    Hello avk,

    Can you provide more detail on how you want to be alerted and on what date the email will be sent?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    THE TOTAL NUMBERS OF CUSTOMER ATLEAST 1000. I WILL ONLY TWO FOR EXAMPLE. Some customer required 12 visit in a year & some customer required 4 or 6 visit in a year. If in column "t" enter more than one email address is it possible to write : abc@yahoo.com; xyz@gmail.com

    Email will be sent before 4 days : Column "q" which is Today date<4 days of any column "e" to column "p" (which is due) on every day one time mail send if today date & due date is 21 april 2010 email will be sent from date 18 april 2010 with msg. 4 days left for due visit, again mail send 19 april 2010 with msg. 3 days left for due visit, 20 april 2010 with msg. 2 days left for due visit & 21 april 2010 with msg. alert last day for due visit. If i enter in column "u" : yes (column u is visit carried out yes/no) after entering yes stop the alert notification.

    In sheet1 : all customer index list.

    Our file location is :
    d:\visit\amc_tracker.xls

    Not required to send attachment only text plain mail. Body of massage like below :

    srno, customername, esn, city, visit due date (which is due on that particular day. Base on column "q" today date < 4 days of any column "e" to column "p" which is due.

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    Bump no reply. Awaiting favourable reply.

  7. #7
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    anyone sort out problem.

  8. #8
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    Bump no reply.

    Now i m more explain you :

    I have using excel 2003. Attach different file for your info.

    I want to forward file address "to" & also copy mark to others "cc". In below code only address "to" write.
    Range from column "b" to "e" but only those which display date. If in column "e" only 1 date show then only those range creat in body of mail. If more date display if display 4 or 5 date then all those display date range at a glance send by email.

    Mail send before 5 days of visit date and continue send upto on visit date.
    If today is 26 april 10 & in file only one date show 01 may 10 then mail send on date 26 april 10, next day 27 april 10, 28, 29, 30 april -10 & 01 may 10 on date mail send.

    I have created code as per below :
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Leith Ross; 04-26-2010 at 04:43 PM. Reason: Added Code Tags

  9. #9
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    bump no reply. Awaiting.

  10. #10
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    I m awating for your reply.

  11. #11
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Sending emails and alerts

    Hello avk,

    Will the CC addresses always be the same or does the macro need to take them from the worksheet? If the CC addresses are on the worksheet then which columns are the addresses in?

  12. #12
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    Thanks. CC address require in vba code & always send email with CC each & every time. Address not mentioned in sheet1.

    Column Range require in email msg. of body : column "b:e"
    customer name, ESN, City, Visit date details send by email.

    Email Send which day: before 5 days from the date of visit & after every day upto visit date email send required.

    Only those tow select the date in which he is sent by email, blank without mentioned date row not consider during sending email. (visit date mentioned in column "e")

  13. #13
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    bump reply awaited.

  14. #14
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Sending emails and alerts

    bump no reply. I m very much need your valuable suggestion / solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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