def generate_message(df, supplier):
    message = f"Expiry Alert for Supplier: {supplier}\n\n"
    for _, row in df.iterrows():
        message += (
            f"Medicine: {row['Medicine_Name']}\n"
            f"Batch: {row['Batch_No']}\n"
            f"Expiry: {row['Expiry_Date'].date()}\n"
            f"Stock: {row['Stock_Quantity']}\n"
            f"Total Expiry Medicine: {row['Medicine_Name']}.value_counts()\n"
            f"Total Expiry Category: {row['Category']}.value_counts()\n"
            "----------------------\n"
        )
    return message