We currently use Excel to produce a breakdown of our employees work through the week so they can see their hourly rate and hours worked which produces a gross amount. We are having to copy and paste each employee's information from their Excel sheet into the body of an email every Friday morning and this is taking up valuable time as we pay 100 people a week.
What I require is a system where Excel sends out this payment breakdown to each employee (so 1 excel sheet per employee) at the touch of a button to save me time.
91 freelancere byder i gennemsnit £118 på dette job
Hello Sir Im excel VBA macro and formula Expert :) i can do make excel template like u need SIr :) Relevant Skills and Experience my main skill in vba macro excel Proposed Milestones £23 GBP - milestone
Hi I can help you with this, i will create a tool using VB.NET it will interact with excel and outlook to do the job You have to add the sheets to a folder select that folder, specify the email body and click GO :)