OutlookのメールをClaude Codeで自動振り分け・自動返信させたら受信トレイ管理が劇的に楽になった体験記【2026年版】

import win32com.client
import pythoncom
import time
import re
from datetime import datetime

def get_or_create_folder(inbox, folder_name: str):
    """指定名のフォルダを取得または作成する"""
    for folder in inbox.Parent.Folders:
        if folder.Name == folder_name:
            return folder
    # フォルダが存在しない場合は作成
    new_folder = inbox.Parent.Folders.Add(folder_name)
    print(f"[{datetime.now():%H:%M:%S}] フォルダ作成: {folder_name}")
    return new_folder

def classify_email(subject: str, sender_addr: str) -> str:
    """メールの分類ルールを返す"""
    subject_lower = subject.lower()
    sender_lower = sender_addr.lower()

    # ルール1: 重要取引先（複合条件）
    if "@important-client.co.jp" in sender_lower:
        if re.search(r"見積|発注", subject):
            return "重要取引先"

    # ルール2: 社内連絡
    if "@mycompany.co.jp" in sender_lower:
        return "社内連絡"

    # ルール3: メルマガ
    if re.search(r"メルマガ|配信停止|unsubscribe", subject_lower):
        return "メルマガ"

    return "未分類"

def auto_sort_inbox():
    """受信トレイのメールを自動振り分けするメイン処理"""
    pythoncom.CoInitialize()
    try:
        outlook = win32com.client.Dispatch("Outlook.Application")
        namespace = outlook.GetNamespace("MAPI")
        inbox = namespace.GetDefaultFolder(6)  # 6 = olFolderInbox

        # 対象フォルダの準備
        target_folders = {
            name: get_or_create_folder(inbox, name)
            for name in ["重要取引先", "社内連絡", "メルマガ", "未分類"]
        }

        moved_count = {name: 0 for name in target_folders}
        messages = list(inbox.Items)  # リストに変換（移動中のイテレータ崩壊を防ぐ）

        for msg in messages:
            try:
                subject = msg.Subject or ""
                sender = msg.SenderEmailAddress or ""
                dest_name = classify_email(subject, sender)
                msg.Move(target_folders[dest_name])
                moved_count[dest_name] += 1
            except Exception as e:
                print(f"  スキップ（エラー）: {e}")

        total = sum(moved_count.values())
        print(f"[{datetime.now():%H:%M:%S}] 振り分け完了: 計{total}件")
        for name, cnt in moved_count.items():
            if cnt > 0:
                print(f"  → {name}: {cnt}件")
    finally:
        pythoncom.CoUninitialize()

if __name__ == "__main__":
    print("Outlook自動振り分けスクリプト起動（毎60秒実行）")
    while True:
        auto_sort_inbox()
        time.sleep(60)

import win32com.client
import pythoncom
import re
from datetime import datetime

# 返信テンプレート辞書
TEMPLATES = {
    "在庫": {
        "pattern": r"在庫|stock",
        "subject_prefix": "【自動返信】在庫確認のお問い合わせ受付",
        "body": (
            "いつもお世話になっております。\n\n"
            "在庫確認のお問い合わせをいただきありがとうございます。\n"
            "現在の在庫状況は翌営業日中に担当者よりご連絡いたします。\n\n"
            "お急ぎの場合はお電話でもお問い合わせください。\n\n"
            "---\nAurant Technologies 営業部\n"
        )
    },
    "納期": {
        "pattern": r"納期|delivery",
        "subject_prefix": "【自動返信】納期確認のお問い合わせ受付",
        "body": (
            "いつもお世話になっております。\n\n"
            "納期に関するお問い合わせをいただきありがとうございます。\n"
            "担当者より3営業日以内にご連絡いたします。\n\n"
            "---\nAurant Technologies 営業部\n"
        )
    },
    "カタログ": {
        "pattern": r"カタログ|catalogue|catalog",
        "subject_prefix": "【自動返信】カタログご請求受付",
        "body": (
            "いつもお世話になっております。\n\n"
            "カタログのご請求をいただきありがとうございます。\n"
            "PDFカタログをメールに添付してお送りします。\n\n"
            "---\nAurant Technologies 営業部\n"
        )
    },
}

REPLIED_FLAG = "AutoReplied_v1"  # 返信済みマーカー（ユーザーフィールド）

def is_already_replied(msg) -> bool:
    """カスタムフィールドで返信済みか確認"""
    try:
        field = msg.UserProperties.Find(REPLIED_FLAG)
        return field is not None and field.Value == True
    except:
        return False

def mark_as_replied(msg):
    """メールに返信済みフラグを付ける"""
    prop = msg.UserProperties.Add(REPLIED_FLAG, 11)  # 11 = olYesNo
    prop.Value = True
    msg.Save()

def auto_reply_inbox():
    pythoncom.CoInitialize()
    try:
        outlook = win32com.client.Dispatch("Outlook.Application")
        namespace = outlook.GetNamespace("MAPI")
        inbox = namespace.GetDefaultFolder(6)

        replied = 0
        skipped = 0

        for msg in list(inbox.Items):
            try:
                sender = msg.SenderEmailAddress or ""
                # 社内メールはスキップ
                if "@mycompany.co.jp" in sender.lower():
                    skipped += 1
                    continue
                # 返信済みメールはスキップ
                if is_already_replied(msg):
                    skipped += 1
                    continue

                subject = msg.Subject or ""
                body = msg.Body or ""
                text = subject + " " + body

                for category, tpl in TEMPLATES.items():
                    if re.search(tpl["pattern"], text, re.IGNORECASE):
                        reply = msg.Reply()
                        reply.Subject = f"{tpl['subject_prefix']} - RE: {subject}"
                        reply.Body = tpl["body"]
                        reply.Send()
                        mark_as_replied(msg)
                        print(f"  ✅ 自動返信[{category}]: {sender} | {subject[:30]}")
                        replied += 1
                        break
            except Exception as e:
                print(f"  エラー: {e}")

        print(f"[{datetime.now():%H:%M:%S}] 自動返信完了: {replied}件送信 / {skipped}件スキップ")
    finally:
        pythoncom.CoUninitialize()

if __name__ == "__main__":
    auto_reply_inbox()

import win32com.client
import pythoncom
import re
from datetime import datetime

# 転送ルール定義
FORWARD_RULES = [
    {
        "name": "クレーム",
        "pattern": r"クレーム|苦情|返品|不具合",
        "match_field": "subject",
        "forward_to": "manager@mycompany.co.jp",
        "note": "クレーム・品質問題担当",
    },
    {
        "name": "法務",
        "pattern": r"契約|法務|訴訟",
        "match_field": "subject",
        "forward_to": "legal@mycompany.co.jp",
        "note": "法務・契約担当",
    },
    {
        "name": "VIPクライアント",
        "pattern": r"@vip-client\.co\.jp",
        "match_field": "sender",
        "forward_to": "vip-support@mycompany.co.jp",
        "note": "VIPクライアント専任担当",
    },
]

FORWARDED_CATEGORY = "自動転送済み"

def has_forwarded_category(msg) -> bool:
    """Outlookカテゴリに転送済みマークがあるか確認"""
    return FORWARDED_CATEGORY in (msg.Categories or "")

def add_forwarded_category(msg):
    """Outlookカテゴリに転送済みマークを追加"""
    cats = msg.Categories or ""
    if FORWARDED_CATEGORY not in cats:
        msg.Categories = (cats + "," + FORWARDED_CATEGORY).strip(",")
        msg.Save()

def auto_forward_inbox():
    pythoncom.CoInitialize()
    try:
        outlook = win32com.client.Dispatch("Outlook.Application")
        namespace = outlook.GetNamespace("MAPI")
        inbox = namespace.GetDefaultFolder(6)

        forwarded_count = 0

        for msg in list(inbox.Items):
            try:
                if has_forwarded_category(msg):
                    continue

                subject = msg.Subject or ""
                sender  = msg.SenderEmailAddress or ""
                forwarded_this = False

                for rule in FORWARD_RULES:
                    target = subject if rule["match_field"] == "subject" else sender
                    if re.search(rule["pattern"], target, re.IGNORECASE):
                        fwd = msg.Forward()
                        fwd.Subject = f"【自動転送】{subject}"
                        fwd.To = rule["forward_to"]
                        fwd.Body = (
                            f"▼ 自動転送ルール: {rule['name']}（{rule['note']}）\n"
                            f"▼ 元の差出人: {sender}\n"
                            f"▼ 転送日時: {datetime.now():%Y-%m-%d %H:%M}\n"
                            f"\n{'='*50}\n\n"
                        ) + (fwd.Body or "")
                        fwd.Send()
                        add_forwarded_category(msg)
                        print(f"  ✅ 転送[{rule['name']}]: {subject[:30]} → {rule['forward_to']}")
                        forwarded_this = True
                        forwarded_count += 1
                        break

            except Exception as e:
                print(f"  エラー: {e}")

        print(f"[{datetime.now():%H:%M:%S}] 自動転送完了: {forwarded_count}件")
    finally:
        pythoncom.CoUninitialize()

if __name__ == "__main__":
    auto_forward_inbox()

import win32com.client
import pythoncom
import re
import openpyxl
from openpyxl.styles import Font, PatternFill, Alignment
from datetime import datetime
from pathlib import Path

EXCEL_PATH = Path("orders_2026.xlsx")
HEADERS = ["メールID", "受信日時", "差出人", "件名", "品番", "数量", "希望納期"]

def init_excel() -> openpyxl.Workbook:
    """Excelファイルを初期化（なければ作成）"""
    if EXCEL_PATH.exists():
        return openpyxl.load_workbook(EXCEL_PATH)
    wb = openpyxl.Workbook()
    ws = wb.active
    ws.title = "受注データ"
    ws.append(HEADERS)
    # ヘッダー装飾
    header_fill = PatternFill("solid", fgColor="0078D4")
    for cell in ws[1]:
        cell.fill = header_fill
        cell.font = Font(color="FFFFFF", bold=True)
        cell.alignment = Alignment(horizontal="center")
    wb.save(EXCEL_PATH)
    return wb

def get_existing_ids(wb: openpyxl.Workbook) -> set:
    """登録済みメールIDのセットを取得"""
    ws = wb.active
    return {ws.cell(row=r, column=1).value for r in range(2, ws.max_row + 1)}

def extract_order_data(body: str) -> dict:
    """メール本文から注文データを正規表現で抽出"""
    patterns = {
        "品番": r"品番[：:]\s*([A-Za-z0-9\-]+)",
        "数量": r"数量[：:]\s*(\d+\s*(?:個|本|枚|セット|箱|ケース)?)",
        "希望納期": r"希望納期[：:]\s*(\d{4}年\d{1,2}月\d{1,2}日|\d{4}[-/]\d{1,2}[-/]\d{1,2})",
    }
    result = {}
    for key, pat in patterns.items():
        m = re.search(pat, body)
        result[key] = m.group(1).strip() if m else ""
    return result

def extract_emails_to_excel(folder_name: str = "受注メール"):
    pythoncom.CoInitialize()
    try:
        outlook = win32com.client.Dispatch("Outlook.Application")
        ns = outlook.GetNamespace("MAPI")
        inbox = ns.GetDefaultFolder(6)

        # 対象フォルダを検索
        target_folder = None
        for f in inbox.Parent.Folders:
            if f.Name == folder_name:
                target_folder = f
                break
        if not target_folder:
            print(f"フォルダ '{folder_name}' が見つかりません")
            return

        wb = init_excel()
        ws = wb.active
        existing_ids = get_existing_ids(wb)
        added = 0

        for msg in list(target_folder.Items):
            try:
                mail_id = msg.EntryID
                if mail_id in existing_ids:
                    continue

                order = extract_order_data(msg.Body or "")
                row = [
                    mail_id,
                    msg.ReceivedTime.strftime("%Y-%m-%d %H:%M") if msg.ReceivedTime else "",
                    msg.SenderEmailAddress or "",
                    msg.Subject or "",
                    order["品番"],
                    order["数量"],
                    order["希望納期"],
                ]
                ws.append(row)
                existing_ids.add(mail_id)
                added += 1
                print(f"  ✅ 追記: {msg.Subject[:30]} | 品番={order['品番']} 数量={order['数量']}")
            except Exception as e:
                print(f"  エラー: {e}")

        wb.save(EXCEL_PATH)
        print(f"[{datetime.now():%H:%M:%S}] Excel保存完了: {added}件追加 → {EXCEL_PATH}")
    finally:
        pythoncom.CoUninitialize()

if __name__ == "__main__":
    extract_emails_to_excel("受注メール")