Email Generation Desktop Application

To quickly summarize the idea:

I have existing emails in your MySQL database.

I will input a new person (First Name, Last Name, Website) into an Excel file.

I want a program to:

Look up the domain (website) in your database.

Analyze the existing email patterns

Generate a possible email address for the new person (1 2 in your example).

Output it into the Excel file.

Step 1: Read the Excel file.
Step 2: For each row, connect to the MySQL database and fetch existing emails for the domain.
Step 3: Detect the most common email pattern for that domain.
Step 4: Generate a new email address for the new person using the detected pattern.
Step 5: Write the generated email back into Excel (say Column D).

Example

Website First Name Last Name Suggested Email


Suppose your MySQL database has these emails for domain abc.com:



I can infer the pattern: first initial + last name first initial last name @1.com).

Similarly, if the emails are like:


Then the pattern is: first name dot last name firstname.lastname @2.com).

The code would automatically detect this and create a correct new email.

Here's the plan:
We’ll build a small desktop app.
I can browse and select the Excel file.
The app will connect to your local MySQL database to fetch email patterns.
The app will generate emails based on the patterns it finds.
I can save the result as a new Excel file.

You will create basic app layout and we will leave it as not found if email is not found

Here's the basic structure we'll start with:
Step 1: Browse to upload an Excel file.
Step 2: Connect to MySQL (we'll pre-configure connection settings inside the app).
Step 3: Process each record (Website + First Name + Last Name).
Step 4: Output the new Excel with emails filled or "Not Found".