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.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)