C# Application for Initiating Word Mail Merge

Project Overview

The client's objective was to streamline their Word mail merge process. They were initially using a VBA-based solution within Excel but wanted a more direct approach. The new solution required a standalone C# executable that accepts specific parameters to handle the mail merge. This would eliminate the need for intermediary text files by directly reading from the database.

Project Highlights

Objective

Design and develop a C# application that replaces a VBA process in Excel, effectively initiating a Word mail merge.

Key Features

  • Parameter Acceptance: The .exe file accepts two essential parameters:
  • Database connection string
  • Template path and name
  • Integration with Excel: Though the VBA code remained within Excel, the portion that initiated Word was seamlessly transitioned to C#.
  • Direct Database Read: Bypassed the need for intermediary .txt files, enabling the application to directly read data from the database.
  • Automatic Closure: After completing the report, the executable automatically closes, ensuring smooth user experience.

Technologies Used

  • C# Programming Language (programiranje.co.rs): The primary development language, chosen for its robustness and compatibility with Microsoft Office operations.
  • Microsoft Word Interop: Used for handling Word operations and mail merge functionalities.

Client feedback

★★★★★5/5

“Great job done, very knowledgeable developer.”