Hi,
I'm new to the forum and have very limited VBA knowledge. I would like to seek your help and guidance to create an excel request and approval form via e-mail.
I created a project cost file to keep track of cost estimates for individual project.
Each tab represent an individual project e.g. 001, 002 etc.and the total project cost is summed up in Summary tab.
The process as follows:
1) The Project Manager keeps a file with all project approval forms
2) The Project Manager will complete the project approval form and submit only the sheet by e-mail to GM for approval, copy the Accountant.
3) The GM will reply to Project Manager whether the request is approved or rejected, copy the Accountant.
4) The Accountant uses the e-mail as the supporting document in processing vendor invoices.
I referred to a previous thread http://www.excelforum.com/excel-prog...m-excel-2.html but only managed to partially construct the required form.
Attached my draft Project Approval file for your easy reference.
Many thanks for your assistance and guidance.
Regards, Tokkwang
Bookmarks