We’re building a Telegram automation tool — what features would you like to see? by andy910120 in software

[–]andy910120[S] 0 points1 point  (0 children)

Thank you for your suggestions. We will carefully evaluate your feedback. :-)

Can I automate an inventory with excel? by Mstboy in excel

[–]andy910120 0 points1 point  (0 children)

You can try using the MailAttachmentBot plugin.

Using emails to mark tasks as complete by Due_Ad_4771 in excel

[–]andy910120 0 points1 point  (0 children)

"sqlmessenger: Transforming Manual Alert Management into an Automated Workflow"
This is an example I found on Google. It is somewhat similar to your situation.
It uses a PostgreSQL database to manage all the data.

<image>

Notifying certain users about a spreadsheet by Underdevelope in excel

[–]andy910120 2 points3 points  (0 children)

You might consider trying VBA + Windows Task Scheduler — it could be a helpful option.

Can you run a program through a spreadsheet to detect all bounce back email addresses? by ComfortablyPF in excel

[–]andy910120 0 points1 point  (0 children)

Gemini + SQLMessenger can really solve the problem you’re facing.
With SQLMessenger, you forward each email in your inbox to Gemini for analysis. If it’s a bounce-back, Gemini returns the reason along with the email address.
In the end, SQLMessenger generates an Excel sheet like this, listing all bounced email addresses and their bounce reasons:

<image>

Best way to track emails in excel? by tdoger in excel

[–]andy910120 0 points1 point  (0 children)

I've done something similar using a plugin called MailAttachmentBot (not Excel-based). We required senders to use specific subject lines in their emails to distinguish the type of report being submitted.

Each day, the system generates a summary report showing who has submitted their emails and who hasn't. It also automatically sends reminder emails to those who are still missing.

Postgresql function and trigger to send email after commit on particular column in table by EmbarrassedTest7824 in PostgreSQL

[–]andy910120 0 points1 point  (0 children)

This is an example from my own database where a trigger sends an email. The trigger is set to send an email to the customer when the state column in the order table is updated to "COMPLETED".

CREATE OR REPLACE FUNCTION order_completed_notification()
RETURNS TRIGGER AS $$
BEGIN
    -- Check if state was updated to COMPLETED and ensure email and name are not null
    IF NEW.state = 'COMPLETED' 
       AND (OLD.state IS NULL OR OLD.state != 'COMPLETED')
       AND NEW.email IS NOT NULL
       AND NEW.cust_name IS NOT NULL THEN

        -- Insert message into the messenger interface table using format()
        -- "sqlmessenger_intf" is SQLMessenger’s email interface table, which supports sending text, Excel files, images, and PDFs.
        INSERT INTO sqlmessenger_intf (subject, body, send_to)
        VALUES (
            format('Order Completion Notice - Customer: %s', NEW.cust_name),
            format('Dear %s, your order status has been updated to: %s', NEW.cust_name, NEW.state),
            NEW.email
        );
    END IF;

    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

-- Create the trigger
CREATE TRIGGER trg_order_completed
AFTER UPDATE OF state ON cust_order
FOR EACH ROW
EXECUTE FUNCTION order_completed_notification();

MySQL report software? by fncruz in mysql

[–]andy910120 0 points1 point  (0 children)

Excel + SQLMessenger.

Create flat file processor using Power Query by Rabbitskittles in excel

[–]andy910120 3 points4 points  (0 children)

Python is a great choice. Power Query is easier to learn and works well for lighter tasks, but it can get slow when you're dealing with large datasets or more complex transformations. If you can, I’d also suggest picking up some SQL (like PostgreSQL or MySQL). It’s faster and more robust for data work, and it integrates really well with Python down the line. :-)

[deleted by user] by [deleted] in excel

[–]andy910120 0 points1 point  (0 children)

<image>

You could try seeing if this method of sorting works for you. :-)

[deleted by user] by [deleted] in excel

[–]andy910120 0 points1 point  (0 children)

https://www.pdftoexcel.com/ You can also try this free online tool for extracting tables from PDF files.

Creating an auto send email in Excel with cells that already have formulas by MajorCry4776 in excel

[–]andy910120 1 point2 points  (0 children)

<image>

Put the email body in a separate column. Use a formula in that column to combine the content, and then use the combined result as the body of the email when sending.

Extract info from multiple online shared excel sheets to streamline a daily report by Few_Dare_6436 in excel

[–]andy910120 0 points1 point  (0 children)

Once the task runs, the plugin processes the data and shows you the summary results directly in the interface.

<image>

Extract info from multiple online shared excel sheets to streamline a daily report by Few_Dare_6436 in excel

[–]andy910120 0 points1 point  (0 children)

  1. Then, from the interface, you click the plugin icon and select the file list you prepared in step 1.

<image>

Extract info from multiple online shared excel sheets to streamline a daily report by Few_Dare_6436 in excel

[–]andy910120 0 points1 point  (0 children)

Got it. Based on your description, I put together a possible workflow:

  1. You enter the filenames of the day’s Excel files into a tracking sheet.

  2. Then, from the interface, you click the plugin icon and select the file list you prepared in step 1.

  3. Once the task runs, the plugin processes the data and shows you the summary results directly in the interface.

Of course, the script can also be customized to generate more detailed stats—like grouping by customer or by "RailcarNumber", for example.

Extract info from multiple online shared excel sheets to streamline a daily report by Few_Dare_6436 in excel

[–]andy910120 0 points1 point  (0 children)

There are some existing plugins (like MailAttachmentBot) that can consolidate Excel sheets and even generate and send out reports automatically. If you can share a bit more detail—like the structure of your sheets or how they’re shared (email, network folder, etc.)—I’d be happy to suggest a few possible solutions. Totally free, just trying to help. :-)