Hello,
This is a very hard one and I am unsure if it is possible to make this happen in excel.
I am looking to have an automatic email sent from excel if a product is sold. The email would need to automatically include a range of cells.
So I thought I could possibly have a column in the sheet which is blank, and if a product sells then I could simply enter an "X" in the cell of that column.
So I am basically looking for -
if X is entered in R9, then email range C9:H9. The subject would have to read "Joe Bloggs has sold a product"
The difficult thing is, that I would need it somehow to automatically change the cell range, dependant on where I put the "X". so if I put the X in R10, it would automatically go for the range c10:h10.
I use outlook 2010 as an email client and excel 2010.
Hoping someone can help out.
Thanks
Chris
Bookmarks