+ Reply to Thread
Results 1 to 4 of 4

Vba code to Auto email based on certain criteria

  1. 03-05-2016, 03:01 AM #1
    xlhelp7
    xlhelp7 is offline
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Vba code to Auto email based on certain criteria

    Hello everyone!
    email message is located in sheet 2, details in Green should be replaced based on sheet 1.for each emailbody data in sheet2 range A14 to D14 should copy from sheet1 range F to I and also data in sheet2 range A19 to E19
    Should copy from sheet1 range J to N and in sheet2 Range A26 to G26 should empty.note that 1 email should be sent per item in column B.subject of email will be same for all email "Column D - Campaign Feedback Awaited".
    Please find the attached sample file
    Any help would be greatly appreciated!

    Regards,
    Xlhelp7
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-05-2016, 07:43 AM #2
    xlhelp7
    xlhelp7 is offline
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Vba code to Auto email based on certain criteria

    Any input!
    Reply With QuoteRegister To Reply
  3. 03-06-2016, 11:48 PM #3
    xlhelp7
    xlhelp7 is offline
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Vba code to Auto email based on certain criteria

    Any input!
    Reply With QuoteRegister To Reply
  4. 03-07-2016, 04:11 AM #4
    xlhelp7
    xlhelp7 is offline
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Vba code to Auto email based on certain criteria

    Any input!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Send Email based on Cell Content
    By tigerdel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2016, 07:36 AM
  2. Auto populating multiple values based on two criteria based in combo boxes
    By smcghin1 in forum Excel General
    Replies: 4
    Last Post: 05-19-2015, 11:53 PM
  3. VBA Code to Auto intialsend email & reminder email based on cell value
    By swk8429 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2015, 06:15 AM
  4. VBA to run auto email code when date becomes yesterday
    By kdean571 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2014, 06:33 PM
  5. Modity on current code to prompt due date & auto email
    By cyee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2013, 04:00 AM
  6. VBA Code for Multiple criteria auto Filter & sending the mails based on that
    By Rajveer1981 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2012, 01:37 PM
  7. Excel 2007 : Auto Email on Workbook open based on dates
    By Chad_Hunt in forum Excel General
    Replies: 1
    Last Post: 06-16-2010, 10:07 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1