Results 1 to 1 of 1

Thread: excel send an email based on cell value (Date)

  1. #1

    excel send an email based on cell value (Date)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,

    I am new for excel and do not know much about VBA or macro script. So wonder if you can help me.

    I have excel sheet and i want to send an email based on date value in excel cell.

    Click image for larger version. 

Name:	excel question.jpg 
Views:	18 
Size:	48.0 KB 
ID:	1166

    as per attachment i have actual loading date colon (L3) and i want to send an email to two users before two days of that actual loading date. I also want to send an email to the same users after 8 days of date of discharge (R3) . I want to add Voyage No (A3) in email weather in subject or in body of email. I do not want to attach sheet with email.

    I would like to send an email weather file is open or closed. i use outlook 2007 and user whom i want to send an email will be same each time.

    i will Highly appreciate if some one can help with this one.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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