Help with Excel Macro - Send email based on cell value.
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.
Any help will be greatly appreciated on this subject.