The GSTIN Mail Merge is a Microsoft Access-based desktop application designed to streamline communication with vendors by providing them with the correct Harmonized System of Nomenclature (HSN) codes for their invoices. Key features include:

• Automated Email Dispatch: Consolidates open Purchase Orders (POs) for each vendor, listing the corresponding HSN codes, and schedules personalized emails through Microsoft Outlook, enhancing efficiency and accuracy in vendor communications.

• Data Integration: Automatically imports and collates data from Excel spreadsheets, ensuring up-to-date information is used in communications and reducing manual data entry errors.

• Scalability: Successfully managed the distribution of HSN code details to over 3,000 vendors, demonstrating the application's capability to handle large-scale operations effectively.

This automation facilitates compliance by ensuring vendors are promptly informed of the correct HSN codes to use, thereby reducing errors in invoicing and improving the overall efficiency of the procurement process.