+ Reply to Thread
Results 1 to 5 of 5

Macro help with sending emails from outlook base on excel dates

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    London
    MS-Off Ver
    MS officer 2013
    Posts
    5

    Macro help with sending emails from outlook base on excel dates

    Hello! I've attached a file that I needed some help with. The macro is something I got from an old post, but I tried to reconfigure it to work on my sheet and it's not working.

    I just need an e-mail to be sent 10 days before the dates in column 3.

    Anyone have any input or guidance it'll be really appreciated!

    Thank you,

    dates22.xlsm

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Macro help with sending emails from outlook base on excel dates

    wow...thankfully the code does not work

    otherwise the file would automatically of sent out a large amount of emails upon opening the file
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    02-09-2015
    Location
    London
    MS-Off Ver
    MS officer 2013
    Posts
    5

    Re: Macro help with sending emails from outlook base on excel dates

    Ahhh I'm very sorry, I'm still very new to vba stuff. I just started my first office job and I have very basic excel experience.

    Please help! Haha much appreciated

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Macro help with sending emails from outlook base on excel dates

    your pivot table is not setup the same way the example was
    you need to tailor either the data or code to suit what you require

    however in your example i cant tell exactly what you require
    you need to be more detailed in your explanation, expectations and subsequently your input/output

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Macro help with sending emails from outlook base on excel dates

    Focus on exactly what you are after
    if there are no check's inserted, you will send the same email to the same person over and over again every time you open the spreadsheet

+ 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. Need a macro that sends out emails from outlook base off of dates in excel
    By Wery123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2015, 10:20 PM
  2. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  3. Sending Outlook emails containing Excel data
    By Richard Buttrey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2009, 10:24 AM
  4. Replies: 1
    Last Post: 09-20-2008, 05:34 PM
  5. [SOLVED] Sending emails from Excel with Outlook Signature
    By Erik in forum Excel General
    Replies: 1
    Last Post: 04-24-2006, 02:20 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