Hi
I am using this macro to look up a range of cells in excel to send in an email body but need to change a few things.
The email is to .Display so I can check before sending.
I need it to look at a sheet called 'To Csh Mgt" to select the range of cells.
Also in the body of the email I need it be to the left hand side in the email, at the moment it centre's it.
Finally to put a "Yes" in another worksheet range I152 once the email has been sent
My comments are in green the original comments are in red.
Many thanks in advance.
Please Login or Register to view this content.
Bookmarks