Hi, I have been finding several macro codes and editing them to my needs but i just could not achieve what I wanted, mainly due to how noob I am at vba.
My aim is to create a code that filters by the cost centre, then copy the filtered columns B to E and paste to a new outlook message.
My outlook message contains the words except the variable:
"Hi,
Please be reminded bla bla bla....QWE (the variable that changes according to the cost centre)
(Followed by the filtered table)
Thank you.
Regards,
bla bla"
I also want the outlook message to have the recipients on it.
Then the entire process continues for the next cost centre, OCP, and next cost centre, CBK. The email text will be the same except for the variable mentioned above.
The attached is a picture of my excel spreadsheet.
Untitled1.jpg
*Note that all information are fictional in this case.
Thank you very much in advance for reading this and assisting me to solve it! Will anyone be able to advise how to start off learning vba as well?
Bookmarks