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 ...
13th June 2011, 03:21 PM #1
- Rep Power
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.
14th June 2011, 09:02 AM #2
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!
By browolf in forum Office Software
Last Post: 15th February 2011, 08:48 PM
By ahuxham in forum Office Software
Last Post: 18th December 2009, 11:27 AM
By park_bench in forum Office Software
Last Post: 5th May 2009, 02:08 PM
By oyoung in forum Windows
Last Post: 30th March 2007, 11:27 AM
By wesleyw in forum How do you do....it?
Last Post: 20th December 2006, 11:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)