Efficiency in B2B Communications: The Benefits of VBA Macro Implementation for Repetitive Tasks

Abstract

The best business relationships are built as relationships between people and organizations that work together to achieve common goals. In the current digital era, B2B collaboration relationships are essential for business success. The response time to customer requests can be a key factor in maintaining these relationships and obtaining a competitive advantage. The use of VBA automation for repetitive tasks can help speed up this process, but it is important that computer operators have medium knowledge about using VBA macros. This work deals with issues related to improving response times to requests received by email, using a macro program for repetitive tasks. The empirical study was conducted on an average of 50 daily emails for order confirmation, with an average writing time of 68 s per email, resulting in a potential reduction in working time for the operator of approximately 1 h/day, only for order confirmation. The results show a significant improvement in working time for computer operators, using VBA buttons for repetitive tasks.