+ Reply to Thread
Results 1 to 4 of 4

Excel macro to send email through outlook when expiry nearing

  1. #1
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    340

    Excel macro to send email through outlook when expiry nearing

    Hi, I am trying to make an inventory list with the expiry date of various chemicals. There is a user form which I have not coded yet. What I hope to do is have the macro send an email regarding which chemical is expiring within 90 days to a group of people. Any help will be appreciated, Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-30-2014
    Location
    England
    MS-Off Ver
    MS Office 2010, 2007, 2003
    Posts
    149

    Re: Excel macro to send email through outlook when expiry nearing

    I've put a macro in called SendMail which will check the date in the D column, and send if the date is equal to today.
    Dead simple to put your own If statement in

    Inventory expiry.xlsm

    It is untested, but based on an email macro I use daily.

  3. #3
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    340

    Re: Excel macro to send email through outlook when expiry nearing

    Hi aaron, thanks for your help. How do I get the macro to send the mail with the body of text that includes the chemical and the date that it is expiring at?

  4. #4
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    340

    Re: Excel macro to send email through outlook when expiry nearing

    oh and i tried the macro. It didnt work though. I didnt receive any emails regarding the expiring chemical

+ 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. [SOLVED] Need a Macro to send email from excel through Outlook basis of different conditions
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2014, 10:21 PM
  2. Macro to send notification from excel to my Outlook Email
    By savethisid in forum Excel General
    Replies: 18
    Last Post: 03-27-2014, 02:25 PM
  3. Replies: 5
    Last Post: 02-22-2013, 02:00 AM
  4. Replies: 1
    Last Post: 10-03-2012, 07:31 AM
  5. Replies: 1
    Last Post: 05-19-2012, 10:33 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1