+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Help with Excel Macro - Send email based on cell value. in Technical; Hi Guys, Just after some help with excel macros. I am useless with this piece of software so pleaseeee make ...
  1. #1

    Join Date
    Aug 2010
    Location
    Nottingham
    Posts
    20
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Help with Excel Macro - Send email based on cell value.

    Hi Guys,

    Just after some help with excel macros. I am useless with this piece of software so pleaseeee make it as easy as poss

    I am making a stock take spreadsheet and have a cell with an IF statement which shows 'Order Now' & 'Stock Full' based on a less than greater than value.

    I want to create a Macro based on this so that if the value is less than 2 the spreadsheet will automatically send out an email to the supplier with the order inside of the email so the text in the email will have to be individual for each product.

    I am unsure how to create Macros in Excel. I know I need to record a Macro but when I have gone to do it I am unsure of the steps I need to follow. I have also read that I will need to code the macro using JavaScript, again something I have no experience of doing.


    Any help will be greatly appreciated on this subject.

    Thanks

  2. #2


    Join Date
    May 2009
    Posts
    3,127
    Thank Post
    276
    Thanked 843 Times in 634 Posts
    Rep Power
    333
    Svarcy. It would also help to see the spreadsheet.

    There are several ways to achieve what you want. You might to scan the range of cells using a range object and use an outlook object to send an email depending on the value of each cell. I'm happy to go into a bit more detail but ... if you don't even know how to record a Macro, then making this simple for you is going to be a lot of work!

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] excel macro
    By browolf in forum Office Software
    Replies: 4
    Last Post: 15th February 2011, 07:48 PM
  2. [MS Office - XP] Excel Macro - If Cell Value
    By ahuxham in forum Office Software
    Replies: 0
    Last Post: 18th December 2009, 10:27 AM
  3. [MS Office - 2003] Excel - Changing cell reference
    By park_bench in forum Office Software
    Replies: 5
    Last Post: 5th May 2009, 01:08 PM
  4. help with excel macro needed
    By oyoung in forum Windows
    Replies: 0
    Last Post: 30th March 2007, 10:27 AM
  5. Excel Cell colour changes
    By wesleyw in forum How do you do....it?
    Replies: 3
    Last Post: 20th December 2006, 10:01 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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