I have a simple excel sheet mointoring outgoing mail. The mail/parcels goes to two places either to security to get clearance first if the parcel is sealed or goes straight to the CEO office. If parcels goes to security then it gets returned back to the office and another transmittal notice is done before it is sent to the CEO office.
I would intially like marco that would help me generate the delivery/transmittal notice (saving me adding the details again). currently I am completing the excel sheet and then opening the word doc and re-entering the details again. If you can come up with a better way to re-design the transmittal notice then that would be great.
I have added a sample excel sheet with further notes along with the transmittal notices - one for normal mail and one for security clearance.
The next stage of this project will be to get everything form driven.
The first part of this project is highly time senstive and will need this completed by 1 day. As this is simply creating a marco I do not anticipate this to take any more than a couple of hours.
Hi, I can do it. I m programmer for years and very familiar with vba for this kind of office automation tasks. Looking forward to hearing you, Cuong NH