[Integrated Practice]From Meeting Notes to Action Items to a Deck

Summary: Turn a meeting transcript into AI-drafted minutes, split it into an action list, and auto-generate a briefing deck — a copy-paste-ready pipeline that runs in 30 minutes.

Level note: This is a cross-tool walkthrough that is really L3-level on the B-series scale (Teams transcription + bulk Outlook import + AI processing). The Outlook task-import section involves VBA; if you have no VBA background, skip that section and complete the step manually.

1. Pain Points — Why We Need This

It is 10 a.m. on Monday. You have just walked out of a 90-minute cross-functional meeting. Three things are now piled on your desk:

• A Teams/Zoom auto-transcript — over 30,000 words of casual chatter that nobody wants to read a second time;
• A pile of verbal commitments — "Old Wang, please follow up on this", "Xiao Li, give me a proposal this week", "Let's reconcile the numbers before month-end" — five minutes after the meeting ends, they are already slipping;
• A PPT your boss wants by 4 p.m.: "Send me what we covered today. 5 slides is enough."

Your usual script probably goes like this: spend 1 hour skimming the transcript and cobble together a "meeting summary" email blast; run the action list through your head, ping a few colleagues on WeChat from memory; throw together the PPT at the last minute by copying a couple of bullet points. With 3 meetings a week, "post-meeting cleanup" eats one-third of your working time.

This article compresses that pipeline to 30 minutes: transcript → AI-drafted minutes → AI-split action list → land them in Outlook/Planner → AI-generated PPT outline → PowerPoint layout. No more "manually re-reading the transcript" in the middle.

The 30-minute estimate assumes: ① ≤ 10 action items; ② a reasonably sized transcript (< 30,000 words); ③ a fixed PPT template (e.g., your company's standard template). Outside that range (say 30+ action items, a 60,000-word transcript, or needing to switch templates), the real-world time stretches to 60–90 minutes — same pipeline, but each individual step gets longer.

This pipeline stitches together five tools: Teams/Zoom (grab the transcript) → an AI chat tool (draft the minutes / split the actions / outline the deck; this article uses Qwen as the example, but feel free to swap in ChatGPT / Kimi / Wenxin Yiyan / Claude or any tool you are comfortable with) → Word (file the minutes) → Outlook Tasks / Microsoft Planner (file the actions) → PowerPoint (ship the deck). AI handles the "translation" in the middle; you handle the "quality control" at three key checkpoints.

2. Target Outputs

When you finish, you will have three deliverables in hand:

1. A structured meeting minutes document (.md or .docx): six standard sections — Meeting Topic / Attendees / Topics & Discussion Points / Decisions / Action Items / Follow-ups — ready to email to attendees and for absentees to catch up on.
2. An action list, landed in Outlook Tasks / Planner: a tabular Action_List_XXXX.xlsx plus real, reminder-bearing, follow-up-able tasks so due dates never degrade into "ASAP" mush.
3. A briefing deck (.pptx, around 8 slides): cover, background, topics, decisions, action overview, next steps, Q&A — ready to present the next morning. Note: the boss's "5 slides is enough" was a rough ask; for a structured briefing, 8 slides works better; if the topics are unusually many, you can compress to 5–6 pages by merging "Decisions" and "Action Overview" into one slide.

Prerequisites:

• You have Word + Outlook + PowerPoint installed (Office 2016 or later will do; this article is written against Microsoft 365 / Office 2019).
• Your company uses Teams or Zoom for meetings, with "Record + Transcribe" enabled by the admin (if it is off, this article includes a fallback).
• Your AI tool handles long input — Qwen, ChatGPT Plus, Kimi, Wenxin Yiyan, Claude all qualify; this article uses Qwen as the example (generous free long-text quota), but you can swap tools — the prompts still work as-is.
• For the VBA section, your Outlook needs "programmatic access" enabled in the Trust Center (covered in the Pitfall Guide chapter).

3. Case Walkthrough

To make this reproducible, we will run it against a specific meeting.

Case background: "Q1 User Growth Retrospective" at an internet company — 1 hour 12 minutes, 6 people, 3 topics. Teams recorded and auto-transcribed it, producing a 32,000-word transcript.

The 6 steps below run in order — steps 1–3 prepare the raw material, 4–5 run the AI flow, step 6 ships the PowerPoint.

Step 1: Grab the meeting transcript (5 minutes)

The cleaner the input, the less work later. This step is the "input" that all subsequent AI work depends on.

Grabbing the transcript from Teams:

1. Open Teams and navigate to this meeting's Chat or Recap page;
2. Find Transcript, click the download icon in the upper-right to get the .docx or .vtt file;
3. If you cannot see "Transcript" — the organizer did not enable "Record + Transcribe" for the meeting. Ask them to turn it on, or just take the audio file and jump to Step 1.5.

UI paths vary slightly across Teams versions, so do not get lost:

• Classic Teams (1.x): meeting chat → Transcript tab → upper-right ⋯ → Download;
• New Teams (2.x / desktop): meeting chat → Recap → Transcript → upper-right ⋯ → Download;
• Teams on the Web: right rail of the meeting chat → under the Recap or Transcript tab.

If you cannot find it in any of those three places, the organizer simply did not enable it — fall back to Step 3's contingency (ask the organizer to retroactively enable it) or jump to Step 1.5.

Pitfall 1: Teams transcription is a tenant-level switch that some companies have disabled. Full path: Teams admin center → Meetings → Meeting policies → [select the relevant policy] → Recording & transcription → Allow transcription = On. All three prerequisites must be met — miss any one and the "Transcript" tab stays hidden:

1. License prerequisite: basic meeting transcription is included in standard Teams licenses (Business Basic/Standard and E1/E3/E5 all have it); Teams Premium is only needed for AI extras such as translated transcripts and intelligent Recap — if you see "Transcript" but no "Recap", you are most likely missing Premium, not transcription;
2. Org policy prerequisite: the "Allow transcription" toggle on the path above must be On;
3. Meeting organizer policy prerequisite: the colleague who scheduled this meeting must also have checked "Allow transcription" in that meeting's options — this is a per-meeting override; even if the org enables it, the organizer disabling it for one meeting still kills it.

Once all three are on, allow 1–2 hours for policy propagation before the "Transcript" tab appears in the client.

Grabbing the transcript from Zoom:

1. Log into the Zoom Web portal and go to the Recordings page;
2. Find this meeting and click "Transcript" → download icon in the upper-right;
3. Default format is .vtt, including timestamps and speaker labels.

After you have the file, copy out the plain text into a Meeting_Transcript_2025XXXX.txt file for later. The next three steps will reuse it over and over.

Step 1.5 (fallback): if your Teams tenant has transcription disabled, Zoom was not used, and you only have an audio file — feed it directly to an AI tool. Qwen, ChatGPT, and Kimi all support uploading audio files now; let the AI convert it to text, then jump to Step 2.

Set your expectations carefully:

• Tongyi Tingwu (not Qwen) is more specialized for long audio (> 1 hour) and noticeably more accurate than general chat models — prefer it for long recordings;
• ChatGPT needs GPT-4o or later for audio support — older GPT-3.5 / GPT-4 do not work; Plus subscribers default to 4o, free-tier availability varies by region;
• Kimi only supported documents and images in its earlier versions; audio support was added later, and long-audio segmentation is not as mature as Tongyi Tingwu's;
• For audio over 1 hour, it is best to pre-split by topic or time segment (FFmpeg, Audacity both work), or use a professional transcription tool first (Tongyi Tingwu, Feishu Miaoji, Tencent Meeting AI) to get clean text, then hand that off to a general-purpose AI — dumping long audio straight into a general AI tends to produce mis-recognized names, dropped words, and scrambled timestamps.

Step 2: Use AI to turn the transcript into meeting minutes (10 minutes)

Open your AI tool of choice (Qwen / ChatGPT / Kimi all work), and paste the following prompt in full:

Prompt:

You are a senior meeting secretary. Please turn the following meeting transcript into a structured Chinese meeting minutes.

[Output Format]
# Meeting Topic
- Time: [extract from transcript; if unavailable, write "To be confirmed"]
- Location/Format: Teams / Zoom / In-person
- Host:
- Attendees: (in order of speaking)

## 1. Topics & Discussion Points
### Topic 1: [one-sentence summary]
- Discussion points: …
- Conclusion: …

### Topic 2: …
…

## 2. Decisions
1. …

## 3. Action Items
| No. | Task | Owner | Due Date | Linked Topic |
|---|---|---|---|---|
| 1 | … | Zhang San | 2025-01-20 | Topic 1 |

## 4. Follow-ups / Next Meeting Agenda
- …

[Requirements]
- Only organize content that actually appears in the transcript; do not fabricate or embellish
- For key information such as amounts, dates, and names that you cannot confirm, mark [To be confirmed]
- In "Action Items", if a due date is not explicit, write "ASAP" and mark [To be confirmed]
- Keep the style concise and objective; avoid filler phrases and exclamation marks

Here is the transcript:
[Paste the .txt content here]

You will get a structured minutes document. In essence, it is Markdown (# / ## / ### are heading levels).

Pitfall — Markdown in Word: when you paste Markdown's # into Word, it does not auto-convert to "Heading 1/2/3" styles — it just pastes as bolded body text, so the hierarchy is invisible. Three fixes:

1. Apply styles manually: after pasting, select each heading and apply Word heading styles with Ctrl+Alt+1 / Ctrl+Alt+2 / Ctrl+Alt+3;
2. Pandoc, one-liner: pandoc Minutes_XXX.md -o Minutes_XXX.docx — headings / lists / tables pick up styles automatically (recommended);
3. Writage plugin: install it in Word so Markdown-to-Word conversion happens automatically on paste.

Copy the result into Word and save it as Meeting_Minutes_2025XXXX_XXX_Retrospective.md or .docx.

One-minute human review: AI occasionally misreads "Director Li said Wang should follow up" as "Director Li will follow up" — spend 1 minute scanning the Attendees and Owner columns and fix the mistakes. That single minute can save you a week of finger-pointing later.

Step 3: Have AI split out the action list on its own (3 minutes)

The minutes already include an "Action Items" section, but the format is not clean enough — feed it to AI again to produce a tidy table that is easy to dump into Outlook Tasks.

Prompt:

Please extract every "task" from the following meeting minutes into a pure table that I can paste straight into Excel.

[Output Format]
| No. | Task Description | Owner | Due Date | Priority | Linked Topic |
|---|---|---|---|---|---|
| 1 | … | … | … | High/Medium/Low | … |

[Requirements]
- "Task Description" starts with a verb and stays under 25 characters
- If "Due Date" is not explicit, write "ASAP"
- "Priority" by due timing: today/tomorrow = High; this week = Medium; otherwise = Low
- "Linked Topic" names which topic from the meeting this task belongs to
- Output the table only, no explanation, no preamble
- If the minutes contain no tasks, output "No tasks"

Meeting minutes body:
[Paste the minutes from the previous step here]

The output will look roughly like this:

No.	Task Description	Owner	Due Date	Priority	Linked Topic
1	Output Q1 channel data retrospective	Zhang San	2025-01-18	High	Topic 1
2	Re-estimate user-acquisition campaign budget	Li Si	ASAP [To be confirmed]	High	Topic 2
3	Draft user-acquisition SOP document	Wang Wu	2025-01-25	Medium	Topic 2

Copy the table into Excel and save it as Action_List_2025XXXX.xlsx. Keep the column order exactly No. | Task Description | Owner | Due Date | Priority | Linked Topic — the VBA script below reads them in that order.

Pitfall 2: AI sometimes misses tasks — verbal cues like "I will send it to you later" often slip past. Skim the "Discussion Points" in the original minutes to make sure nothing was dropped.

Step 4: Land the action list in Outlook Tasks / Planner (5 minutes)

An action list sitting in Excel is useless — it has to live somewhere with reminders and follow-up.

Option A: Outlook Tasks (good for individuals / small teams, ≤10 items)

For ~10 tasks, typing them one by one into the Outlook task pane is the most reliable — 30 seconds per task, done in 5 minutes.

If that feels too slow, or you have dozens of tasks, this VBA script batch-imports them from Excel:

In Outlook, press Alt + F11 to open the VBA editor, then Insert → Module and paste this code:

vba
Sub ImportTasksFromExcel()
    ' 把当前打开的 Excel 文件中"任务清单"sheet 的内容批量导入到 Outlook 任务
    ' 本脚本采用"后期绑定"（As Object + 常量数值），无需在 VBE 工具 → 引用 里勾选
    ' "Microsoft Outlook XX.X Object Library"，复制即可跑。
    Dim xlApp As Object, xlWB As Object, xlWS As Object
    Dim r As Long, lastRow As Long
    Dim taskSubject As String, taskDue As String
    Dim t As Object
    Const olTaskItem As Long = 1   ' Outlook 枚举：olTaskItem = 1（任务项）

    ' 关联已经打开的 Excel
    Set xlApp = GetObject(, "Excel.Application")
    If xlApp Is Nothing Then
        MsgBox "请先打开那个任务清单 Excel 文件，再运行本宏。", vbExclamation
        Exit Sub
    End If
    Set xlWB = xlApp.ActiveWorkbook
    Set xlWS = xlWB.Sheets("任务清单")

    ' 找 B 列最后一行（B 列是任务描述）
    lastRow = xlWS.Cells(xlWS.Rows.Count, "B").End(-4162).Row

    For r = 2 To lastRow  ' 第 1 行是表头，从第 2 行开始
        taskSubject = "[" & xlWS.Cells(r, "F").Value & "] " _
                      & xlWS.Cells(r, "B").Value & " （负责人：" _
                      & xlWS.Cells(r, "C").Value & "）"
        taskDue = CStr(xlWS.Cells(r, "D").Value)

        Set t = Application.CreateItem(olTaskItem)
        t.Subject = Left(taskSubject, 255)
        t.Body = "来源会议：" & xlWB.Name & vbCrLf _
                 & "关联议题：" & xlWS.Cells(r, "F").Value & vbCrLf _
                 & "优先级：" & xlWS.Cells(r, "E").Value
        ' 只有当截止日期是真正的日期时才赋值
        If IsDate(taskDue) Then t.DueDate = CDate(taskDue)
        t.ReminderSet = True
        t.ReminderTime = Now + 1  ' 提醒时间设为明天
        t.Save
    Next r

    MsgBox "搞定！已导入 " & (lastRow - 1) & " 条任务到 Outlook 任务栏。", vbInformation
End Sub

How to use:

1. First open your Action_List_XXXX.xlsx and rename the sheet to 任务清单;
2. The header order must be No. | Task Description | Owner | Due Date | Priority | Linked Topic;
3. In the Outlook VBA editor, press F5 to run ImportTasksFromExcel;
4. Switch to the Tasks pane on the left of Outlook, refresh, and you will see all tasks.

If your header order differs, just adjust the column references in the code (e.g., if Task Description is in column D, change Cells(r, "B") to Cells(r, "D")).

Option B: Microsoft Planner (good for team collaboration, >10 items)

If more than one person will follow up on this, drop it into Planner — everyone can see progress:

1. Open tasks.office.com in a browser and sign in with your work account;
2. Select the relevant Plan (project/product) → choose a Bucket (e.g., "Q1 Follow-up");
3. Create tasks one by one — recommended title format: [Topic X] Task description (Owner XXX);
4. Set the Due date and assign to the right colleague.

Pitfall 3: Planner has no native "bulk import" button — typing them in one by one is currently the most reliable path. For larger lists (> 20 tasks), pick one of these three:

1. Power Automate + Excel template batch import (recommended): build a flow in Power Automate that reads a template Excel and creates Planner tasks; a single run can import dozens — details in §6 Advanced Extensions;
2. Microsoft Graph API: call POST /planner/plans/{plan-id}/tasks to bulk-create tasks — requires Azure AD app registration + Planner API permissions; this is the developer route;
3. Fallback: first land the tasks in Outlook Tasks via the VBA above, then ask each colleague to "claim" their tasks inside Planner — one extra hop but faster than manual entry.

Step 5: Use AI to generate the PPT outline (5 minutes)

Action list landed. Next up: turn "what we covered in the meeting" into a briefing deck.

Back to your AI tool. Paste this prompt:

Prompt:

Based on the meeting minutes below, generate an 8-page PPT outline for reporting back to leadership.

[Per-page Output Format]
---
## Page N: [page title]
- Bullet 1
- Bullet 2
- Bullet 3
- Speaker notes: [2-3 sentences telling me how to talk through this page]
---

[Requirements]
- Page 1 is the cover: title + subtitle + presenter + date
- Page 2 is meeting background and agenda
- Middle pages are topics and decisions (one page per topic)
- Second-to-last page is a table-formatted action-item overview
- Last page is next steps + Q&A
- Style: workplace briefing; avoid jargon like "empower", "lever", "closed-loop", "sync up"
- Overall, an absent colleague should grasp what happened in 5 minutes

Meeting minutes body:
[Paste]

AI will give you 8 "page skeletons" — each with a title, a few bullets, and a couple of speaker-note sentences.

Why not ask AI to write the .pptx directly? Asking AI for a .pptx file typically yields ugly templates, rigid layouts, and overloaded text. Generate the outline first, then choose your own layouts in PowerPoint — the quality gap is huge. Get the outline right and the deck is 80% done.

Step 6: Turn the outline into a deck in PowerPoint (10 minutes)

Open PowerPoint and walk through these 3 sub-steps:

1. New presentation, pick a clean template (Microsoft's built-in "Facet" or "Ion" are both fine — avoid the flashy ones);
2. Open Outline view: View → Outline View, then paste the 8 pages of "page title + bullets" from Step 5;
3. Switch back to the Slides view and go page by page, dropping the bullets into the right text boxes, tweaking fonts and adding visuals.

Lazy tips:

• If you are on Microsoft 365 with Copilot entitlement, try PowerPoint's Copilot to summarize the .docx and auto-build a deck — but Copilot picks the template / layout automatically and may not faithfully reproduce your outline's hierarchy (your "Topic 1 / Topic 2 / Action Overview" pages might get merged or split). Prerequisite: a Copilot license (it is paid, and corporate availability in your region depends on the company);
• If you do not have Copilot, try Chinese AI PPT tools like AiPPT.cn / Xunfei Zhiwen, or mainstream Western ones like Gamma.app / Meitu AI PPT — paste the outline and let them auto-generate the pages. Caution: double-check template licensing and watermarks before sharing, or you will get laughed at by colleagues.

After these 6 steps you will have in hand:

• A Meeting_Minutes_XXXX.md (Word / Markdown)
• An Action_List_XXXX.xlsx + actual tasks in Outlook Tasks / Planner
• A Briefing_Deck_XXXX.pptx

4. How It Works — A Quick Recap

In one sentence: take the unstructured verbal information called "a meeting", run it along the chain "transcript → text → structured → tasks → slides", and at every step let AI do the "translation", with a human doing the "quality control" at the key checkpoints.

AI handles three kinds of work in the middle:

1. Text cleaning: cut filler, repetition, and tangents; keep decisions and facts;
2. Structure extraction: pull "who, when, action, deadline" out of running prose;
3. Content rewriting: condense bullets into 30-second talking points for the deck.

Humans only need to step in at three checkpoints: check names, check tasks, check deadlines. AI for efficiency, humans for the safety net — that is the most stable pattern for AI in the office.

5. Pitfall Guide

I hit 5 pitfalls along the way so you do not have to:

1. "Let AI attend the meeting for me" is wishful thinking: AI cannot sit in on the discussion or make the call. It can only help you organize after the meeting. Do not try to have AI live-summarize an in-progress meeting and ship those notes as the official minutes — misattributions and missing voices cause way more trouble later.

2. Dirty transcripts: many companies' Teams / Zoom transcription gets punctuation and names wrong ("Wang Wu" might come out as "Wang Wuu"). Spend 2 minutes in Step 1 fixing obviously wrong names and the AI organization that follows will be much more accurate.

3. Due dates are a "hallucination hot spot": people say things like "ASAP", "this week", "early next month" in meetings, and AI often fabricates a specific date. Tag every unclear date [To be confirmed] in the minutes, and have each owner confirm verbally before the document goes out — that one round of confirmations saves you a week of pestering calls.

4. Do not aim for "fully automatic" PPT outlines: the outline is AI-written, but layout, colors, and animations must be chosen by a human. Fully AI-generated slides have an unmistakable "AI flavor" — once leadership has seen a few, they will think you do not care. AI writes the skeleton, humans fill in the flesh — that is the safe card for workplace reporting.

5. The Outlook VBA script will pop up "Allow access?" the first time: just click "Allow". If it keeps asking, go to File → Options → Trust Center → Trust Center Settings → Programmatic Access → choose "Never warn me about suspicious activity" (only set this on your own machine, and only when you are sure of the macro's source). Prerequisite: your company's IT has not locked this setting via Group Policy / Intune — many large enterprises force "Always warn"; in that case you cannot change the client-side setting, just click "Allow" manually every time the macro runs — 3 seconds, do not fight IT on this, and do not ask IT to unlock it (compliance risk).

6. Advanced Extensions

If you want to push this further, three directions to take it one step:

• Stitch it together with automation: use Power Automate as the trigger — when a Teams meeting ends, automatically push the transcript to AI → AI produces the minutes → auto-email the attendees. You only need to click "Approve" before sending. That chain is not expanded here; a dedicated Power Automate article is coming.
• Dial the VBA up further: the Outlook batch-import script above is just the starting point. Have it auto-send an email to each owner at import time: "AI has split N tasks out of yesterday's meeting for you; they have been added to your Outlook Tasks — please confirm your due dates." — that is real "AI-driven workflow".
• Longitudinal tracking across meetings: name each week's minutes file using a 2025-W03-XXX pattern, dump them all into one folder, and let AI auto-generate a "Monthly Project Progress Summary" each week — kiss your weekly-report anxiety goodbye.

Summary

Meeting minutes → action list → deck sounds like three different things, but in AI's eyes it is just three expressions of the same text.

What you learned today is not a tool — it is a way of thinking:

1. Turn unstructured information into text first;
2. Let AI refine it, again and again;
3. Have humans cover the critical checkpoints;
4. Land the output somewhere that can "nag" people (Outlook Tasks / Planner), do not let it stop at a document.

Apply this same mindset to "client interview → requirements doc" or "user research → product proposal" — they work the same way.

Next step: take the VBA script from this article and run it yourself — do not just read it. Drop it into your Outlook VBA editor and press F5; the feeling is completely different. If it breaks, paste the error in the comments and I will take a look.