[ms office - 2003] Help with Excel Macro - Send email based on cell value.

[Svarcy]

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

[pcstru]

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!