+ Reply to Thread
Results 1 to 2 of 2

VBA: Automatically send email based on a Criteria

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    VBA: Automatically send email based on a Criteria

    hi, i am seeking help on how to automate below process and write a vba.

    Case: i have an excel file whereby column K = date, column E, G = email address that i am going to send an email to. header is in row 2.
    usually, i will filter to column K the month that i am working on, send an email to each customer base on the respective Column E, G cell for the email address.
    in the email subject, will indicate "reminder - [customer]" -> customer will be the value found in column A
    Email content:
    line 1: hi,
    line 2: this is line 2.
    line 3: copy the table over with header row 2 and its respective row (without column I and J)

    example: if i filter to Mar 2020, i will need to send 3 emails out.
    the 1st email will be sent to E3, G3, subject: reminder - A3
    hi, this is line 2, copy the table from range A2:L2 and A3:L3(without column I and J)

    2nd email will look like this.
    send to E6, G6, subject: reminder: A6
    hi, this is line 2, copy the table from range A2:L2 and A6:L6 (without column I and J)

    thanks in advance.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    05-05-2014
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: VBA: Automatically send email based on a Criteria

    hi, anyone able to guide me? thank you.

+ 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. Send E-Mail Automatically Based on Criteria & Periodically from a Shared Network Folder
    By Rajeshkumar R in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-26-2019, 07:25 AM
  2. Automatically match Email ID & send email
    By yashagarwal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2016, 04:36 AM
  3. Macro to automatically send screenshot to an email address if cell criteria are met
    By zeegerman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2015, 01:10 PM
  4. Macro to send out email based on criteria
    By MD011 in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2015, 10:34 AM
  5. Automatically send an email based on the value of a cell and/or trigger date
    By psn.arya in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 06:17 PM
  6. Send Email Based on Spreadsheet Criteria
    By WDP in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2005, 07:05 PM
  7. automatically send email in excel based on value/macro guru stuff
    By Michael A in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2005, 05:05 PM

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