关于扩展Outlook快速步骤快捷键数量及宏教程需求的问询

Hey Gideon, great question—you’re spot on that macros are the perfect workaround for Outlook’s 9 quick step shortcut limit, especially when paired with your Stream Deck. Let me walk you through a no-fuss setup to create and use these macros:

1. Enable Macros in Outlook First #

Before diving in, you need to make sure Outlook allows macros:

• Go to File > Options > Trust Center > Trust Center Settings > Macro Settings
• Choose either Enable all macros (safe if you’re only running your own code) or Notifications for all macros to approve them manually
• Restart Outlook to apply the change

2. Open the VBA Editor & Create a Module #

• Press Alt + F11 to launch the Visual Basic for Applications (VBA) editor. Alternatively, if you see the Developer tab (enable it via File > Options > Customize Ribbon if not), click the Visual Basic button there.
• In the left-hand Project Explorer pane, right-click your Outlook account > Insert > Module—this is where you’ll write your macro code.

3. Write a Sample Macro (Move Emails to a Folder) #

Here’s a simple macro that moves selected emails to a specific folder. Customize it for your needs:

Sub MoveToCustomerFollowUp()
    Dim objMail As MailItem
    Dim targetFolder As Folder
    
    ' Update this path to match your target folder
    ' Example: If your folder is under Inbox, use this line:
    Set targetFolder = Application.Session.GetDefaultFolder(olFolderInbox).Folders("客户跟进")
    
    ' If your folder is a top-level folder, use this instead:
    ' Set targetFolder = Application.Session.Folders("your-email@domain.com").Folders("Top-Level Folder")
    
    ' Loop through selected emails and move them
    For Each objMail In Application.ActiveExplorer.Selection
        objMail.Move targetFolder
    Next objMail
    
    ' Clean up objects
    Set objMail = Nothing
    Set targetFolder = Nothing
End Sub

• Just change the folder name ("客户跟进") to match the folder you want to use, and repeat this code block for each additional folder you need—each gets its own named macro.

4. Assign a Keyboard Shortcut to Your Macro #

• Back in Outlook, go to File > Options > Customize Ribbon
• Click the Customize button next to Keyboard Shortcuts at the bottom of the window
• In the Categories dropdown, select Macros, then pick your new macro from the Commands list
• Press the shortcut you want to use (e.g., Ctrl+Shift+C), click Assign, then close the windows

5. Link to Your Stream Deck #

• Open your Stream Deck software, add a new Hotkey action
• Paste or select the keyboard shortcut you assigned to the macro
• Name the button something clear (like "Move to Customer Follow-Up") and save—you’re all set to trigger the macro with a single tap!

Quick Tips #

• Backup Your Macros: Right-click your module in the VBA editor > Export File to save it as a .bas file. This lets you restore your macros if Outlook updates or resets.
• Digital Signatures: To avoid Outlook blocking your macros, create a self-signed test certificate via the Developer tab’s Digital Signatures tool—this marks your macros as trusted.

备注：内容来源于stack exchange，提问作者Gideon Sassoon